Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Server Based Repositories


You can create a model in any edition of Enterprise Architect as a .eap file. However, if you need to develop large models with many concurrently-connected users, you might prefer to use the greater capacity and flexibility of a Data Base Management System (DBMS) and create your project on a DBMS (server-based) repository. This facility is available through the Corporate, Business and Software Engineering, Systems Engineering or Ultimate editions.

Set up a project on a DBMS repository

To set up your project on a DBMS repository, you work through these stages:

1.Set up your DBMS software and create a repository.
2.Create the required tables in your repository, by running a script supplied on the Sparx Systems website.
3.(For certain DBMS products) Set up an ODBC driver to enable connection to the repository.
4.Transfer the project from the source .eap file to the DBMS repository; the source .eap file can be:
a .eap template file, to begin a new project from scratch, or
a previously-developed project .eap file, to move an existing project into the DBMS repository
5.Connect to your repository.

DBMS Products you can use

You can set up your project on a repository in:

SQL Server 2000, 2005, 2008 or 2012
SQL Server Express 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, or
Oracle 9i, 10g or 11g

For information on creating a project on a specific DBMS from this list, see Learn more, below.


You cannot move a model from a source .eap file of an Enterprise Architect version earlier than 3.5.0 without updating it first
Before proceeding, you must have MDAC 2.6 or higher installed on your system
(Optional, but recommended) before actually transferring the project structure from the .eap file to the repository, perform a Project Data Integrity Check on the .eap file

Learn more