Mapping Tables and Views

dbForge Fusion allows you to map tables or views with non-equal names. This topic contains instructions on custom table and view mapping.

By default, when you move to the Mapping tab of the Data Comparison wizard, dbForge Fusion 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 icons.

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.

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 will appear.

    Object Mapping

  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. Click 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 opens.

    Object Mapping

  2. Select Query or Table radio buttons 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 the Cancel button to close the dialog and discard mapping.

Click the Reset button to restore the automatic mapping of objects.