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
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 .EAP 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 .EAP file to a DBMS repository such as SQL Server or MySQL |
| • | Transfer a DBMS repository to a .EAP 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:
|
|
||||||||
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.
|
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 |
| • | 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
