Q: How to compare tables with different structure?
A: Mapping allows comparing two tables that have different structure (number and name of fields).

You should select fields of primary and secondary table in the dialog box and click "Map column". To delete column association you don't need, you should select them in the mapping list and click "Unmap". Using control or shift keyboard buttons you can select and remove a few associations at once. "Clear Map" removes all column maps.

"Automatically" map feature creates mapping for columns with same name automatically.

The map constant value feature allows the user to fill secondary table by predefined value during synchronization or to compare secondary column with constant value. In this case the program compares secondary value with predefined constant instead of column's value from the primary table. Please enter constant value, select secondary column name and press "map constant" button to create this type of map. It is important to quote entered value if necessary (strings, dates, etc). For NULL value you should use <NULL> string.

Conversion Feature

The program allows the user to apply built-in database function of the target database for some columns. It is most useful for custom format conversion like date, time, etc.
To apply conversion function please:

• Select source and target fields
• Enter conversion expression into "Conversion" field. You should use '%s' instead of actual field value, for example: CAST(%s AS decimal(10,5))
• Click "Map column" button.

Notes:

• The program shows mapping button pressed if mapping specified for current pair of tables:
• The mapped columns are marked by green icon when not mapped by red.
• You may map a column more than once for complex table to table relationships.