Tables & mapping overview
Set the rules for every table, then the exceptions.
Last updated November 6, 2026
The Tables & mapping step shows the tables on the left and what you set on the right. Three buttons above the list open the rules for every table. Clicking a table opens that table.
What each part sets
| Part | What you set there |
|---|---|
| The table list | Which tables run, whether to include new source tables, and the name of each in the destination. See Choose the tables. |
| Table defaults | What every table copies and what happens to a table that already exists. See Table options. |
| Naming rules | The case of every name, characters to replace, a prefix or suffix. See Choose destination names. |
| Type mapping | The destination type for each source type, in every table. See Change a column type in every table. |
| A table | That table only: Table options, Filter rows…, and the Columns, Indexes and Foreign keys tabs. See Override one table. |
Options for the whole job are on the other two steps:
- Setup: the mode and the synchronization method.
- Execution: worker threads.
See Job options.
Marks in the lists
Each table in the list has a status: new table, or what the run does to the one already there: replaces existing, empties existing, adds to existing. A table with something to review also shows warning.
In a table's columns, the Status column marks:
- in red, what stops the run: Duplicate (two columns get one name), Will not fit (the type cannot hold the values);
- in amber, what to review: Lossy (part of a value is lost), Reserved (a reserved word in the destination);
- your own changes: Rename, Override.
Point at a mark to see why. The check covers every selected table, including tables outside the visible part of the list. The line at the bottom counts the issues and opens the list. See Pre-migration checks.