Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

Server Based Repositories


If you purchase the Corporate, Business and Software Engineering, Systems Engineering or Ultimate editions, you can upsize the .eap templates (such as EABase.eap) or any existing .eap project to a DBMS data repository.

A DBMS repository enables you to support larger models with more concurrently connected users.



See also

Supported DBMSs

SQL Server 2000, 2005 or 2008
MySQL 4 or 5
PostgreSQL 7, 8 or 9
Adaptive Server Anywhere 8 or 9, or SQL Anywhere 10, 11 or  12
Access 2007
Progress OpenEdge
Oracle 9i, 10g or 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.

You cannot move a model from a source .EAP file of a version earlier than 3.5.0.


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