This topic describes how to create a PostgreSQL repository.
Sparx Systems provides SQL scripts to create the required Enterprise Architect repository tables, on the Sparx Systems website. You can execute the scripts in any way you prefer. However, if you are unfamiliar with PostgreSQL and DBMS systems in general, you might want to consider a suitable front end tool.
One such tool is pgAdminIII, which is available at http://www.pgadmin.org/download/. It provides a convenient graphical user interface to enable creation of databases, execution of scripts and restores.
To get started with pgAdminIII, follow the steps below:
- Create a new database.
- Open and execute the PostgreSQL SQL script.
- Below is an example showing the tables created in the PostgreSQL repository after running the script in pgAdminIII.
PostgreSQL repositories are created without any data, so you must perform a project data transfer in Enterprise Architect to copy a suitable starter project. If you are starting from scratch, EABase.EAP is a good starting point. If you are using an existing .EAP model, you can upsize it.