Server Based Repositories

project_data_tranfer

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.

Topic

Detail

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
  • MSDE or
  • 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