Versions Compared

Key

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

...

  1. Select a row by highlighting it with the cursor. (The check box is irrelevant for this task.)
  2. On the right side of the pane, click View Column Mapping.
  3. In the Columns and Comparison Key pane, you can:
    • Select or deselect columns to use in the comparison job. Because this could affect referential integrity, review Resolution Options.
    • Change or add a comparison key if multiple keys are available. In the Comparison Filter pane, you can:
      • Write a WHERE clause to use during the comparison.
      • Create a different WHERE clause per table in the pair. Select Separate Where Clause and an additional text box is added for a second WHERE clause.

        Info

        When entering selective WHERE clauses, do not include the WHERE keyword; for example, use “AGE>12” instead of “WHERE AGE>12”.

...