Review the action plan and warnings
Action plan
On the Summary page of the Data Synchronization wizard, you can also review the action plan of your synchronization.
Action plan comprises the list of synchronization actions in the order they are to be performed.
If you want to see the details of any action, click an arrow button next to it to expand the list.
You can also click the Expand all button 
to see the description of all actions.
To locate a required action, you can type the search text in the Search box.
Warnings
Synchronization warnings are displayed on the Summary page of the Data Synchronization wizard. These warnings are the same as column level Mapping Warnings. But mapping warnings appear regardless of real data differences, they are generated if there are column datatype differences, which may cause errors or data loss in the tables to compare. Synchronization warnings appear only if there are data to be updated or inserted to the target table.
If you encountered synchronization warnings, the synchronization may fail or data loss may occur because of truncation or rounding. If the warning has the Error icon, then the error will certainly occur when executing the synchronization script. To avoid this error, exclude this table or corresponding records from the synchronization by clearing the corresponding checkboxes in the Data Comparison grid.
The list of Data Compare warnings
| Warning | Description |
|---|---|
| Disable foreign key | A foreign key might not recover after synchronization |
| Foreign key Warning | Table X has foreign key to the table Y. Synchronization may fail |
| Keys and Indexes Warning | Synchronization process may cause loss of disabled keys and indexes |
| Source column allows Nulls which can not be stored in target | Source column A allows Nulls which can not be stored in target column B, migrating the data may cause an error |
| Conversion is possible, but may fail in case of incompatible data | Conversion between columns A and B is possible, but may fail in case of incompatible data |
| Columns have different precisions | Columns A and B have different precisions, migrating the data may cause overflows. |
| Date or time columns have different data format | Date or time columns A and B have different data format, migrating the data may cause truncation |
| Columns have different precisions or scales | Columns A and B have different precisions or scales, migrating the data may cause rounding or overflows |
| Columns have different sizes | Columns A and B have different sizes, migrating the data may cause truncation |
| Columns have different collations | Columns A and B have different collations |
| Convert table Archive Engine To InnoDB | Target’s table has an ARCHIVE engine and synchronization can be failed |
| Check constraints warning | A check constraint might not recover after synchronization |
Want to Find out More?
Overview
Request a demo
