Perform a Project Data Transfer

In normal system maintenance, it is likely that at some point you need to relocate data between storage systems. In any edition of Enterprise Architect, you might need to transfer all records from one project file to another (recommended after serious network crash or repeated database corruption). In the Corporate, Business and Software Engineering, System Engineering and Ultimate editions of Enterprise Architect, you might need to:

Transfer an existing project file to a DBMS repository such as SQL Server or MySQL
Transfer a DBMS repository to an existing project file
Move a repository from one DBMS to another (including moving between servers using the same DBMS)
Copy all records from a JET 3.5 to JET 4 (Access 2000 or XP) repository - or back the other way
 

Access    Tools | Data Management | Project Transfer

Perform a project data transfer

Step

Action

See also

1

Click on the option for the required transfer type:

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

 

 

2

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

 

 

3

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

 

 

4

Click on the Transfer button.

 

 

5

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

 

Compare Projects

Notes

Take a backup of the target project to ensure that you can recover any important information it already contains; in a transfer, 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
When performing an EAP to DBMS transfer, if the EAP file has replication enabled, the replication must be removed before performing the transfer
When transferring a model to a DBMS, you cannot transfer the data into an empty database - the tables must already exist; if they do not, run the corresponding script supplied by Sparx Systems to create the required tables
When transferring a model into a project file, similarly, the target project file must already exist, to provide the data structures to transfer data into
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