Database Compare


Database compare is used to view the differences between the design and server databases.

It can also be used to synchronize the design with what is on the server. For example, if changes have made directly to the server, those changes can be applied to the design by synchronizing the design with the server.

Another use of this design synchronization feature is if design changes have been made but those changes are no longer wanted. Use the design synchronization feature to revert the design to what is on the server.

Compare Databases:

Select the appropriate server connection in the Connection combo box.

On the Tools menu, click Database Compare.


Database Compare Panel

Click Refresh. DbWrench will analyze the database on the server and compare it with the design database.

All of the entities not matching between the design database and the server database are displayed in the grid, with a brief explanation of the difference.

To synchronize the design database with any differences on the server:

In the grid, select the entities to synchronize. Use Ctrl-A to select all.

Click Sync Design.


See also:

Managing Connections