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

Perform a Project Data Transfer

The Corporate, Business and Software Engineering, System Engineering and Ultimate editions of Enterprise Architect support a range of data repositories.

At some point, it might become necessary to move a complete model from one repository to another, row by row, table by table.

Access:    Tools | Data Management | Project Transfer

Use to:

  • Upload an existing .EAP file to a SQL Server or MySQL repository
  • Download a repository in MySQL or SQL Server to a .EAP file
  • Move a repository from SQL Server to MySQL or from one server to another
  • Move all records from a .EAP file with replication to a model with none (Remove Replication)
  • Copy all records from a .EAP file to another (recommended after serious network crash or repeated database corruption)
  • Copy all records from a JET 3.5 to JET 4 (Access 2000 or XP) repository - or back the other way

How to:

To perform a project data transfer, follow the steps below:

Step

Action

See also

1

Take a backup of the  target project to ensure that you can recover any important information it contains

 

2

Select the Project Transfer menu option

The Project Transfer dialog displays

 

3

Click on the option for the required transfer type:

  • .EAP to .EAP
  • DBMS to .EAP
  • .EAP to DBMS
  • DBMS to DBMS

 

4

In the Source Project and Target Project fields, type or select the name or connection string for the Source and Target projects

 

5

If you want to capture the transfer in a log file, select the Logfile checkbox and browse for the appropriate log file location

 

6

Click on the Transfer button

 

7

It is good practice to do a Project Compare after this process to verify that all records are written

Compare Projects

Notes:

  • All records in the target repository are overwritten
  • You cannot move a model from a source .EAP file of a version earlier than 3.5.0
  • You must transfer data into a repository (where scripts have been run to set up tables), not just a database; if necessary, follow the steps below:
  • Install the DBMS software and create a database; ensure that the collation is set to the alphabet you use, such as Latin or Cyrillic
  • Run a script supplied by Sparx Systems to create the required tables
  • In the Corporate, Business and Software Engineering, System Engineering and Ultimate editions of Enterprise Architect, if security is enabled you must have Transfer Data permission to transfer project data between repositories

Learn More: