Server Based Repositories

project_data_tranfer

Introduction

The Desktop and Professional versions of Enterprise Architect use an MS JET database as the model repository.

If you purchase the Corporate, Business and Software Engineering, Systems Engineering or Ultimate edition, you can also create and use any of the following data repositories:

You upsize the Enterprise Architect models (either existing or template) to use your selected DBMS. The process of upsizing a model is straightforward and comprises the following steps:

  1. Install the DBMS software and create a database. Ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic.
  2. Run a script supplied by Sparx Systems (http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts) to create the required tables.
  3. Open Enterprise Architect and use the Project Data Transfer function (select the Tools | Data Management | Project Transfer menu option) to move a model from a .EAP file to the DBMS repository.

Note:

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

Setting up a database repository is a two- or three-stage process: firstly, you set up an ODBC driver for your database; secondly, you create the repository tables using scripts downloaded from the Sparx Systems web site; and finally, you connect to the repository. Full instructions on all three stages are provided below.

Set Up an ODBC Driver

Setting up an ODBC driver is only necessary for MySQL, PostgreSQL, Progress OpenEdge and Adaptive Server Anywhere. These database management systems require specific set-up in order to operate as a repository. Other database management systems connect through OLE DB and do not require a driver, so this stage can be skipped.

Note:

For Oracle, the Microsoft OLE DB Provider for Oracle is not appropriate. You use the Oracle Provider for OLE DB instead.

To find out how to set up an ODBC driver, go to:

Create a Repository

To find out how to download the scripts and create the data repository tables, go to:

Connect to a Repository

Once the repository is created, you can connect to it.

Note:

To connect to a repository, you must have the usual SELECT, UPDATE, INSERT and DELETE permissions.

To find out how to connect to your repository, see one of the following topics: