Server Based Repositories


You can create a model in any edition of Enterprise Architect as a .eap or .feap 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 file to the DBMS repository; the source file can be:
·a .eap or .feap template file, to begin a new project from scratch, or
·a previously-developed project 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 or
·Oracle 9i, 10g, 11g or 12c

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 file to the repository, perform a Project Data Integrity Check on the file

Learn more