SQL Compare 9

Synchronizing data sources

When you have reviewed the comparison results, you can run the synchronization wizard to create the SQL script to synchronize the selected objects:

  1. Select the objects that you want to synchronize.
  2. Click  Synchronization Wizard to start the Synchronization wizard.

Selecting the objects to synchronize

By default, no objects are selected for synchronization. You can modify the selection by using the check boxes in the middle of the upper (Results) pane:

Object selections are remembered when you save a project.

To select all the objects in a group for synchronization, select the check box on the grouping bar for that group; alternatively, you can right-click within the group and click Include All Objects in this Group.

To exclude all objects displayed in a group from the synchronization, clear the check box; or, you can right-click the group and clickExclude All Objects in this Group.

The top level check box in the central column enables you to include or exclude all objects that are displayed in the upper (Results) pane:

You can filter the object types and use the Find box to assist you with your selection.

Note that if you select an object for synchronization and then set up a filter that excludes that object type, the object is not included in the synchronization. Only selected objects that are shown in the comparison results are included.

For example, if you select TableA for synchronization, and then set up a filter to exclude all tables, no tables are shown. If you subsequently remove the filter, TableA is displayed and remains selected for synchronization.

Example: Selecting objects that exist only in the source

  1. In the Filter pane, to the left of the results, ensure that the default filter Nothing Excluded is selected, so that all the objects are displayed in the upper (Results) pane.
    No objects are now excluded by the filter.
  2. Ensure the top level check box in the central column is cleared, or on the Actions menu select Exclude All.
    No objects are now selected for synchronization.
  3. From the Group by box, select Type of difference if it is not already selected. On the grouping bar for objects that exist only in <source database name>, select the check box to include all of the objects in this group.

Example: Selecting only stored procedures

  1. From the Group by box, select Type of difference if it is not already selected.
    The objects are now grouped by whether they are different, identical, or present in only one of the data sources.
  2. In the Filter pane, select and clear the All object types included check box, and then select the check box for Stored Procedures.
    Only Stored Procedures are now displayed in the upper pane.
  3. Select the top level check box in the central column to include all objects in the synchronization.

Example: Selecting only tables that exist in both databases but are different

  1. From the Group by box, select Type of difference if it is not already selected.
    The objects are now grouped by whether they are different, identical, or present in only one of the data sources.
  2. In the Filter pane, clear the All object types included check box, and then select the check box for Tables.
    Only Tables are now displayed in the upper pane.
  3. Clear the top level check box in the central column to exclude all objects from the synchronization.

    No objects are now selected for synchronization.

  4. On the grouping bar for objects that exist in both but are different, select the check box to include all of the tables in this group in the synchronization.

 

 


Didn't find what you were looking for?