Author Topic: Compare/update data model with another data model  (Read 3590 times)

kepNCI

  • EA User
  • **
  • Posts: 127
  • Karma: +1/-0
    • View Profile
Compare/update data model with another data model
« on: January 11, 2012, 08:41:02 am »
Need a way to compare and possibly update a data model in one project a data model in another project, thus keeping them in sync, including baseline information in both projects and not loosing links.

On our MS SQL EA repository there is an EA project that defines our production environment, including appr 13 data models that were initially created via re-engineering (MS SQL and Oracle). For security reasons, the PCs that access the EA repository does not have access to our producion databases. So I have a eap project on a PC that does have access which I use to ODBC import to update the models,  comparisons to last baseline and then create new baselines. I would like to be able to replace/update the data models on the EA repository with the models from production.

Using package or element export/import via XML or via clipboard does not work because it create new models/elements. If I first delete the model on the EA repository project and then import the new model from the EAP (production) project, then I loose the baselines as well as I break any links to the original data model/diagrams (such as in other package diagrams or model document definitions.