Viewing the comparison results

After you have compared the data sources, Schema Compare displays the comparison results in the upper part of the Results window. There you can select objects for synchronization.

Results window

If you need to compare the data sources again using the same project settings, and update the comparison results, click the Refresh button Refresh button or press F5.

In case you need to change the settings, click the Edit Comparison Edit Comparison button button.

By default, the results are grouped for display by status. For convenience when working with the results of the comparison, you can use other options for grouping the results:

Group the comparison results

The Owner column displays the owner (or schema) of the object.

If you want to check the tables that were automatically mapped, you can click the Edit Comparison button and switch to the Table Mapping tab.

Selecting objects for synchronization

The number of objects that will be deployed is shown above the table with the results.

Objects to be deployed

By default, all objects are selected.

If you don’t want to deploy an object, click to unselect a check-off box next to it.

If you want to change the operation with the object, click the cell of this product in the Operation column and select the required operation from the drop-down list.

Select operation

Finding an object

If you want to locate objects, type the search text in the Search box.

Search results

To clear the Search box, click the cross button next to it.


The search is not case-sensitive.