Mapping Tables and Views

By default, when you move to the Mapping tab of the Data Comparison wizard, Data Compare for MySQL 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.

How to unmap an object:

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

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

    Object Mapping

  3. Click the Map button and the mapped objects disappear from the Objects Mapping dialog and will be shown in the Mapping tabs grid.

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

Tips:

Click Cancel to close the dialog and discard mapping.

Click Reset to restore the automatic mapping of objects.