Book a Demo

Author Topic: How to duplicate the EA Database and reset all GUID?  (Read 3867 times)

Dan.W

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
How to duplicate the EA Database and reset all GUID?
« 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?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to duplicate the EA Database and reset all GUID?
« Reply #1 on: March 16, 2023, 03:58:50 pm »
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
« Last Edit: March 16, 2023, 04:02:10 pm by Geert Bellekens »