Database Compare


Database compare is used to synchronize database entities that may have been added, removed or modified directly on the database server with the design in DbWrench.

Sychronize the Design:

On the Tools menu, click Database Compare.


Database Compare Panel

In the Database Compare panel that appears, select the appropriate server connection in the Connection combo box.

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.

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

Click Sync Design. As entities are synced the background color of the row will be shaded grey and the 'Synced' column will be updated.

Click Refresh to view only the remaining unsynced entities.


See also:

Managing Connections