SQL Scripts Adaptive Server Anywhere

Before you set up EA for use with ASA, we recommend you run the Tools | Data Management | Data Integrity tool on the base project you wish to upsize to ASA. This will ensure data is 'clean' before uploading.

 

Warning: Before proceeding, ensure MDAC 2.6 or 2.7 is installed on your system.

 

 

Upsizing Your Database

There are four stages to upsizing your database for ASA. Follow them in order:

 

Stage One: Install ASA Components

 

1. Install Adaptive Server Anywhere  - SQL Anywhere Studio 8 or higher. This will also install the ASA ODBC driver.

 

2. Create a new database for the EA repository using Sybase Central.

 

3. Create a suitable ODBC Data Source to point to your new database.

 

Note: See Set up an ASA ODBC Driver.

 

 

Stage Two: Configure the Database

 

From Sybase Central, right click on the newly created database and open  Interactive SQL. Load the ASA_BaseModel.sql file. This is available to registered users on the Corporate Edition resources page of the Sparx website at http://www.sparxsystems.com/registered/reg_ea_corp_ed.html.

 

Run the script to create all required tables/indexes etc.

 

Note: See Create a New ASA Repository.

 

 

Stage Three: Transfer the Data

You now have an empty database - you can use the Tools | Data Management | Data Transfer menu option to transfer an existing model into the server.

 

1. Open EA.

 

2. Go to the Tools | Data Management | Data Transfer menu option. This will open the Full Model Transfer Dialog.

 

 

ASA-FullModelDataTransfer                

 

 

3. Select .EAP to DBMS as the Data Transfer Type.

 

4. Click the Browse [...] button to the right of the Source Model and locate the .EAP file to upsize to ASA.

 

5. Click the Browse [...] button to the right of the Target Model. This will open the Datalink Properties Dialog.

 

6. Select "Microsoft OLE DB Provider for ODBC Drivers" from the list, then press the Next button.

 

7. From the Use data source name drop down list, select the ODBC Data Source you configured to point to your new database.

 

Note: See Connect to a ASA Data Repository for more information.

 

8. Press OK.

 

9. If desired, check the Logfile checkbox and enter a path for the data transfer log file.

 

10. Press the Transfer Data button to begin the data transfer process.

 

Once the process is completed, you will have upsized your model to Adaptive Server Anywhere and can now open it from Enterprise Architect.