Upsize to PostgreSQL

You upsize your model repository to a PostgreSQL database in the following stages:

Stage One: Install PostgreSQL Components

  1. Install PostgreSQL, version 7.3.2 or higher.
  2. Install psqlODBC, version or higher (but do not use version 8.4.1).
  3. Create a suitable ODBC Data Source to point to your new database.

Stage Two: Configure the Database

  1. 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. This is available from the Sparx Systems website.
  2. Run the script to create all required data structures (that is, create the repository).


See the Create a PostgreSQL Repository topic.

You now have an empty database repository, into which you can transfer an existing model.

Stage Three: Perform Integrity Check

Run the project integrity check tool (select the Tools | Data Management | Project Integrity Check menu option) on the base project that you intend to upsize to the PostgreSQL repository, to ensure the project data is 'clean' before uploading.

Stage Four: Transfer the Data

  1. Open Enterprise Architect and select the Tools | Data Management | Project Transfer menu option. The Project Transfer dialog displays.
  2. In the Transfer Type panel, select the .EAP to DBMS radio button.
  3. In the Source Project field, type the name of the .EAP file to upsize to PostgreSQL.
  4. At the right of the Target Project field, click on the [ ... ] (Browse) button. The Data Link Properties dialog displays, showing the Provider tab.
  5. Select Microsoft OLE DB Provider for ODBC Drivers from the list, then click on the Next>> button. The Connection tab displays.
  6. In the Use data source name field, click on the drop-down arrow and select the ODBC driver you have set up to connect to your PostgreSQL repository.
  7. Click on the Test Connection button to confirm that the details are correct.
  8. If the test does not succeed, revise your settings. If the test succeeds, click on the OK button. The Project Transfer dialog redisplays.
  9. If required, select the Logfile checkbox and type a path and filename for the data transfer log file.
  10. Click on the Transfer button to begin the data transfer process.

Once this process is complete, the content of the .EAP model exists on the Postgre SQL repository and you can now open the repository from Enterprise Architect.


  • If an error message displays reporting '...nonstandard use of \\ in a string literal...', set the server variable in the postgresql.conf file to:

escape_string_warning = off

  • You cannot transfer a source .EAP file that was created using a version of Enterprise Architect earlier than 3.5.0.