Mapping Tables and Views

By default, when you move to the Mapping tab of the Data Comparison wizard, Data Compare automatically maps all available objects of the selected databases.

Note:

To remap already mapped objects, unmap them first. See the “How to unmap an object” section below.

Note: After objects are mapped for comparison and synchronization, you may encounter mapping warnings, displayed as Caution icons. For more information about mapping warnings see the Mapping Warnings topic.

How to unmap an object:

  1. Switch to the Mapping page of the Data Comparison wizard.

    Mapping Page

  2. In the grid, select database objects to unmap. (To find a mapped database object quickly, use the Filter box. Type the string in this box to view only the objects, containing this string in their names. Click the arrow button to select a recent search. To clear the Filter box, click the (X) button.)

  3. Click the Unmap button on the toolbar. The unmapped objects disappear from the grid, but will be listed in the Object Mapping dialog box.

How to map an object:

  1. Switch to the Mapping page of the Data Comparison wizard.

  2. Click the Map Objects button on the toolbar. The Objects Mapping dialog appears.

    Object Mapping

    Note: Actual document look may slightly vary from the above image depending on the product you use.

  3. Select source and target objects in the corresponding boxes.

  4. Click the Map button and the mapped objects disappear from the Objects Mapping dialog and will be shown in the Mapping tab’s grid.

  5. Repeat steps 3-4 until you map all the objects you need. Press OK to close the dialog.

How to map an object using custom queries:

You can use this option to compare custom results received after query execution instead of comparing whole tables or views. For this, you should:

  1. Click the Custom Query button on the Mapping page of the wizard. The Custom Queries Mapping dialog box appears.

    Custom Query

    Note: Actual document look may slightly vary from the above image depending on the product you use.

  2. Select Query or Table radiobuttons for Source and Target.

  3. If you selected Table for both, refer to the How to map an object section of this topic. If you selected Query for Source, Target or both, write query name in the field (if the name assigned by default is not appropriate).

  4. Type the needed query in the SQL field.

  5. Click Validate to validate your queries, if necessary.

  6. Click Map.

  7. Click OK to close the dialog box.

Tips:

Click Cancel to close the dialog and discard mapping.

Click Reset to restore the automatic mapping of objects.