How do I update a Data Model?

[Riebert]

I reverse-engineerded a Data Model. When a change is made to the database, I also want to update my Data Model. The problem is that if I import a changed table from the database my layout in EA is ruined!! Is there an option I don't know about, which can solve my problem??

[rescobar]

Good question. When you add for example a join between two tables that were not in the original reversion, there is no way to synchronize the model.
Moderator: please let us know how to avoid this problem.
Thanks a lot

[jaimeglz]

Hi Riebert; hi rescobar,

After you have imported your tables into the model, and after you made your diagram tidy: Have you tried importing new tables into another (say, temporary, or staging area) diagram? You can then copy the new table (Ctrl+C) into the tidy diagram (Ctrl+V), put it where you wish, and then you only have to tidy the relationships.

Hope this helps,

Jaime Gonzalez