SQL Data Compare 11

Setting up the deployment

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

Selecting the rows to deploy

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

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

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 the target 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 deploy:

  1. Click a table or view to display its row differences.
  2. Click the appropriate tab to view the type of row differences.
  3. Select or clear the check boxes in the Include column as required.

Selecting the rows to deploy using keyboard shortcuts

To select a row for deployment, 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

You can also use SHIFT+Click and CTRL+Click to highlight multiple rows.


Didn't find what you were looking for?