Embarcadero ER/Studio – Updating the Physical model with database changes

If you’ve reverse-engineered an existing database and then made updates to the physical database here is how you can refresh the model.

  1. Select the Main Model under the Physical option on the Data Model pane.
  2. Right-click on the model diagram and choose the Compare and Merge utility option.
  3. Choose the Compare against a live database option.
  4. Choose the following prompts according to your needs. At the end you will see the differences between the physical model and the database and have the options to import or ignore the objects.

4 thoughts on “Embarcadero ER/Studio – Updating the Physical model with database changes

  1. Power user tip!: If you do frequent operations like this (e.g. reverse engineering or comparisons against the same databases with the same authentication/options/settings/etc), use ER/Studio’s”Quick Launch” system. Each wizard is equipped with it. Walk through the wizard(s) once, set your preferences then save them with the Quick Launch system. When you have to do the procedure again, voila! Instant time savings!

  2. Great post, Mario.

    You can also save the results of your compare for future reference or as an audit trail of the changes. We save our compare reports, then map them to the issues in our change management system for traceability.

  3. An impressive share! I’ve just forwarded this onto a coworker who was doing a little research on this. And he in fact ordered me dinner simply because I found it for him… lol. So allow me to reword this…. Thanks for the meal!! But yeah, thanks for spending some time to talk about this topic here on your web page.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s