SQL Compare 14

Viewing the difference summary

In addition to the SQL differences view, SQL Compare's summary view provides are more succinct view of the differences between two database objects. Rather than showing the full SQL creation script for each object, the summary view shows only the differences between two objects in a structured hierarchy:

Here, we can see that there is one column to be added (DateOfBirth), a column whose nullability will changed (DateJoined) and a primary key constraint that has been renamed.

To use the summary view, first select a difference in the upper results pane, then toggle between the SQL difference view and the summary view using the tab controls on the bottom pane:

The summary view can be opened in a separate window using the  button on the toolbar and the font size can be adjusted from the  settings menu.


Didn't find what you were looking for?