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
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:
|
|
||||||||
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.
|
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 |
| • | 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
