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



See also


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




Select the Project Transfer menu option.

The Project Transfer dialog displays.




Click on the option for the required transfer type:

.EAP to .EAP




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




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




Click on the Transfer button.




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


Compare Projects


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
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