Upsize to Sybase Adaptive Server Anywhere (ASA)

1

Open the base project or template .eap file.

2

Select and run Tools | Data Management | Project Integrity Check.

This ensures your project data is 'clean' before uploading.

Project Integrity Check

1

Install Adaptive Server Anywhere - SQL Anywhere Studio 8 or higher.

This also installs the ASA ODBC driver.

2

Using Sybase Central, create a new database for the Enterprise Architect repository.

Create an Adaptive Server Anywhere Repository

3

Open Interactive SQL and load the ASA_EASchema.sql file.

Sparx Systems Website

4

Run the script to create all required data structures.

Create an Adaptive Server Anywhere Repository

5

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

Set up an Adaptive Server Anywhere ODBC Driver

1

Open Enterprise Architect.

Click on the Cancel button on the Open Project screen to open with no project loaded.

2

Select the Tools | Data Management | Project Transfer menu option.

The Project Transfer dialog displays.

3

In the Transfer Type panel, select .EAP to DBMS.

4

In the Source Project field, type the name of the .EAP file to upsize to ASA.

5

At the right of the Target Project field, click on the ( ... ) (Browse) button.

The Datalink Properties dialog displays.

6

Select Microsoft OLE DB Provider for ODBC Drivers from the list.

Click on the Next button.

7

In the Use Data source name field, click on the drop-down arrow and select the ODBC Data Source you configured to point to your new database.

Click on the OK button.

Connect to an Adaptive Server Anywhere Data Repository

8

If required, select the Logfile checkbox and type a path and filename for the data transfer log file.

9

Click on the Transfer button to begin the data transfer process.