O'Reilly logo

Data Modeling Made Simple with ER/Studio Data Architect by Steve Hoberman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 16

Compare/Merge Utility

The same they should be

Compare and Merge bring order

Life is back in check

The Compare and Merge Utility allows you to reconcile differences between models in the same file or between a model and a database. For example, you have designed and created a model and then created a database based on that data model. A data modeler alters the model and adds the attribute Employee Gender to the Employee entity, while independently, a database administrator alters the Department table in the database and adds a column Department Name to the table. The model and the database are no longer in synch. Applying the Compare and Merge Utility can identify differences such as these, and merge the model and database so they are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required