Setting up the synchronization - SQL Data Compare

When you have reviewed the comparison results, select the rows you want to synchronize, and run the Synchronization wizard.

Selecting the rows to synchronize

By default, all rows that differ are selected for synchronization.

Use the check boxes in the upper (Results) pane to select rows for synchronization:

Object selections are remembered when you save a project.

All Different for all rows that are different for a table or view
for all rows in a table or view that exist in the source but do not exist in the target
for all rows in a table or view that exist in both databases but the rows are different
for all rows in a table or view that exist in thetarget but do not exist in the source

You can also use the Actions drop-down menu to select rows:

Include All and Exclude All select and clear the check boxes for all rows.
Include All in Source and Exclude All in Source select and clear the check boxes in the (only in source) column.
Include All Different and Exclude All Different select and clear the check boxes in the (different) column.
Include All in Target or Exclude All in Target select and clear the check boxes in the (only in target) column.

Note that the Actions drop-down menu is not available if you are viewing the comparison results in a single list.

Use the lower (Row Differences) pane to select individual rows to synchronize:

To select a row for synchronization, highlight the row and press SPACEBAR to select or clear its check box.

To highlight multiple rows:

For the previous or next row, press SHIFT+UP or SHIFT+DOWN
For all rows from the current row to the first or last row, press CTRL+SHIFT+HOME or CTRL+SHIFT+END
For all rows, press CTRL+A