Upsize to PostgreSQL

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 PostgreSQL, version 7.3.2 or higher.

2

Create the empty database.

Create a PostgreSQL Repository

3

From the PSQL command line, or using a tool such as the PostgreSQL command line, pgAdminIII or EMS PostgreSQL Manager, load the PostgreSQL_EASchema.sql file.

Sparx Systems Website

4

Run the script to create all required data structures.

Create a PostgreSQL Repository

1

Install psqlODBC, version 7.03.01.00 or higher (but do not use version 8.4.1).

2

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

Set up a PostgreSQL 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 SQL Server.

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

On 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 a PostgreSQL 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.