Viewing the SQL differences

The lower part of the Comparison Results window displays differences in the creation SQL script for an object.

SQL differences window

Click an arrow button if you want to collapse or expand an SQL comparer:

Expand

Viewing 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.

Code for object creation

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 to customize the view.

SQL differences view toolbar

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

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

Show lines

View white spaces button The View white spaces button displays whitespace characters as symbols.

White spaces display

View hex button The View hex button converts code to hex.

Sort button The Sort button sorts columns and constraints alphabetically.

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

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

Right-click menu

Viewing 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.

Viewing the schema update script

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

Update script