If you’ve reverse-engineered an existing database and then made updates to the physical database here is how you can refresh the model.
- Select the Main Model under the Physical option on the Data Model pane.
- Right-click on the model diagram and choose the Compare and Merge utility option.
- Choose the Compare against a live database option.
- 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.