Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Topic |
Prev | Next |
Create a Project in a PostgreSQL Database
To create a project in a repository on PostgreSQL 7, 8 or 9, you work through these stages:
- Stage 1: Create an empty database repository and set up the data tables
- Stage 2: Set up the PostgreSQL ODBC Driver
- Stage 3: Perform a project integrity check on the project file you are using as a base (optional, but recommended)
- Stage 4: Transfer the data
- Stage 5: Connect to the repository to open the project
Prerequisites
Create Database Repository
Step |
Action |
See also |
---|---|---|
1 |
Create the empty database. |
Create a PostgreSQL Repository Registered User's Scripts page Trial User's Scripts Page |
2 |
Load the EASchema_PostgreSQL_1220.sql file from the Sparx Systems website into your SQL management console of choice (such as pgAdminIII). |
|
3 |
Run the script to create the required database schema. |
Set Up the ODBC DSN
Step |
Action |
See also |
---|---|---|
1 |
Create a suitable ODBC Data Source to point to your new database.
Select these extended options: Page 1: Disable Genetic Optimizer - Uncheck Use Declare/Fetch - Check Unknowns as LongVarChar - Check Bools as Char - Uncheck Max Varchar - 1024 Max LongVarChar - 1000000
Page 2: bytea as LO - Check Disallow Premature - Check Protocol - 7.4+ |
Set up a PostgreSQL ODBC Driver |
Perform a Project Integrity Check
Step |
Action |
See also |
---|---|---|
1 |
In Enterprise Architect, open the file-based project or template from which you are creating the project on the repository. |
|
2 |
Select and run the 'Configure > Model > Check Integrity > Project Integrity' ribbon option. This ensures your project data is 'clean' before being copied to the repository. |
Project Integrity Check |
Transfer the project data to the repository
Step |
Action |
See also |
---|---|---|
1 |
Open Enterprise Architect. (If the 'Open Project' dialog displays, click on the to open with no project loaded.) |
|
2 |
Select the 'Configure > Model > Transfer > Project Transfer' ribbon option. The 'Project Transfer' dialog displays. |
|
3 |
In the 'Transfer Type' panel, select 'File to DBMS'. |
|
4 |
In the 'Source Project' field, click on the If the .EAP file has Replication enabled, this must be removed before performing the transfer. |
Remove Replication |
5 |
At the right of the 'Target Project' field, click on the The 'Datalink Properties' dialog displays. |
|
6 |
Select 'Microsoft OLE DB Provider for ODBC Drivers' from the list. Click on the . |
|
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 . The 'Project Transfer' dialog redisplays. |
Set up a PostgreSQL ODBC Driver |
8 |
If required, select the 'Logfile' checkbox and type a path and filename for the data transfer log file. |
|
9 |
Click on the to begin the data transfer process. |
|
10 |
When the process is complete, you have created a project on a PostgreSQL database and can now connect to it and open it from Enterprise Architect. |
Connect to a PostgreSQL Data Repository |
Notes
Learn more