Reconcile a Database Diagram with a Modified Database

Background information

You save your database diagram when you are ready to update the database to match your database diagram. However, if other users have updated the database since you opened your database diagram, their changes might affect your database diagram and vice versa. In such cases, saving your database diagram will automatically:

• Recreate database objects that are referenced in your database diagram but that another user deleted.
• Preserve triggers that were added to a table; triggers that were deleted from a table are not preserved.
• Delete an object you deleted in your database diagram, even if another user edited that object.

Saving your database diagram will reconcile the database with your database diagram by overwriting other usersÆ changes so that the database will match your database diagram.

Reconcile your database diagram with a modified database

1. In the Database Designer, click Save .

   If you have not previously saved your database diagram, type a name for the database diagram in the Save As dialog box and choose OK.

2. The Save dialog box lists the tables that will be affected when you save your database diagram. Choose Yes to continue.
3. The Save dialog box lists the objects that were modified and will be changed to match your database diagram. Choose Yes to save the database diagram and accept the list of changes.

   Note   If your database diagram contains tables and columns that were deleted in the database, only their definitions are recreated in the database when you save your database diagram. This process does not restore any data that existed in these objects before their deletion.