Server Based Repositories


When you create a model in any edition of Enterprise Architect, you can create it as a .eap file (stored in a Microsoft JET database).

If you have the Corporate, Business and Software Engineering, Systems Engineering or Ultimate editions, you have the option of upsizing the .eap templates (such as EABase.eap) or any existing .eap file to a DBMS data repository. A significant advantage of a DBMS repository is that it supports larger models with more concurrently connected users.

Upsizing to a DBMS repository



See also

Supported DBMSs

SQL Server 2000, 2005 and 2008
SQL Server Express 2005 and 2008
MySQL 4 and 5
PostgreSQL 7, 8 and 9
Adaptive Server Anywhere 8 and 9, and SQL Anywhere 10, 11 and 12
Access 2007
Progress OpenEdge
MSDE and
Oracle 9i, 10g and 11g



Upsize Project to DBMS Repository

To upsize the Enterprise Architect models (either existing or template) to use your selected DBMS:

1.Install the DBMS software; how you do this is explained in your DBMS documentation and beyond the scope of the Enterprise Architect documentation.
2.Create a repository and run a script supplied by Sparx Systems to create the required tables.
3.Set up an ODBC driver to enable connection to the repository(not all DBMSs require this).
4.Open Enterprise Architect and perform a Project Integrity Check on the project .eap file (existing or template); this ensures the data is clean before uploading.
5.In Enterprise Architect, open the Project Transfer dialog, connect to the .EAP file and the repository, and transfer the project data from the .EAP file to the DBMS repository.


Create a Repository

Sparx Systems Scripts

Set Up an ODBC Driver

Check Project Data Integrity

Connect to a Data Repository

Perform a Project Data Transfer


You cannot move a model from a source .eap file of an Enterprise Architect version earlier than 3.5.0 without updating it first