Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: Dan.W on March 16, 2023, 01:47:06 pm
-
We are working on a new project that inherits from an existing one. We need to create a new EA database and fulfill the following requirements:
1. Duplicate an existing EA database.
2. Reset all GUIDs in the new database.
We have attempted the following methods, but none have been successful:
1. Using the mysql dump command to copy a database and import it to a new SQL DB (failed, since the GUIDs remain the same).
2. Using the EA application's export XML feature (failed, the database is too large and the process becomes stuck).
3. Using the EA application's "Copy" -"Full structure for duplication" features to duplicate the database (failed, the database is too large and the process becomes stuck).
Does anyone have any solution to meet our requirements?
-
I think the only way is to use an xml export/import with the option "strip guid's).
In version 16 there is a native xml format that might be a lot faster than xmi.
If it's still too big to do all at once, you'll have to to do it part by part, making sure to follow the dependencies in your model.
That will only work if the parts are completely independent. If not you will loose the relations between the different parts when using strip guid's.
Geert