Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To view columns and rows to resolve

On the Results tab in the Comparison Results table, click View in the row you want to resolve. See Review Comparison Results for context.

The Database Results tab appears, and the Results Overview table displays the pairings in the selected tables.

Image Added

The Results Overview - Activation pane includes:

...

  • Source and target database columns

...

  • Number of matched rows between the source and target.

...

  • Rows that exist only in the source database.

...

  • Rows that exist only in the target database.

...

  • Number of differences between the two databases.

To view data in the columns

  1. Select a row from the Results Overview table.
  2. Examine the row information in the Selected Table pane.

To specify how the data synchronization is resolved

  1. Under the Selected Table pane, click All, Mismatched, Source, Only Source, Target, or Only Target.
  2. In the Data Diff view, choose a one of the following Row Synchronization option options:
    • Make Target Match Source for Selected Row
    • Make Source Match Target for Selected Row
    • Do Not Resolve Selected Row

To generate an SQL script

  1. At the bottom right of the Database Results, click Generate an SQL Script.
  2. In the SQL Editor, review the script and edit it is as needed. For more information, see SQL Editor.

...