Data Compare for Oracle 2

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 Results pane to select rows for deployment:

  • All Different for all rows that are different for a table
  •   for all rows in a table that exist in the source but do not exist in the target
  •   for all rows in a table that exist in both databases but the rows are different
  •   for all rows in a table 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.
The Actions   drop-down menu isn't available if you're viewing the comparison results in a single list.

Object selections are remembered when you save a project.

Use the Row Differences pane to select individual rows to deploy:

  1. Click a table 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?