View SQL differences

Last modified: March 12, 2024

The bottom section of the comparison results window presents the differences found in the SQL script related to the object creation.

Click an arrow button to collapse or expand a SQL comparer.

To learn how to remove objects that have the Only in Target status, see Exclude all objects with the Only in Target status.

View differences

A code that is different is displayed with a colored background. If the object doesn’t exist, the code for its creation is displayed only on one side.

This code will be added if you choose to synchronize databases.

SQL differences view toolbar

For the convenience of reviewing the SQL differences, Schema Compare has a toolbar, allowing you to customize the view.

The Word-wrap button breaks long lines for a more convenient view.

The Show line numbers button displays a column of sequential line numbers at the left side of the box with code.

The View white spaces button displays whitespace characters as symbols.

The View hex button converts code to hex.

The Sort button sorts columns and constraints alphabetically.

The Format Database Object Script button formats the SQL script.

If you want to view a code comparer in a detached window, click .

You can also right-click the window with the code and select a required view option from a menu that appears.

View the schema update script

To view the deployment script for the selected object, right-click it in the upper pane and then click View Schema Update script.

The Update script for the object will be displayed in the lower part of the Comparison Results window.