Review the action plan and warnings
Last modified: March 12, 2024
Action plan
After you have selected objects for synchronization and clicked Synchronization, the Schema Synchronization Wizard appears.
Go to the Summary page if you want to review the action plan of your synchronization.
The 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 Expand all to see the description of all actions.
To locate a required action, you can type the search text in the search box.
Warnings
On the Warnings tab, which is next to the Action plan tab, you can see the list of warnings that can affect the synchronization.
Synchronization warnings
A comprehensive list of all Schema Compare synchronization warnings is given below.
Warnings related to columns comparison and synchronization
- Columns X and Y are included in comparison, but will be excluded from synchronization.
- Columns X and Y are excluded from comparison, but will be included in synchronization.
- The script has columns with the same names. Mapping doesn’t allow it.
Warnings related to possible data loss
- Possible data loss.
- Application-time period data will be lost.
- Cannot synchronize table X using ALTER TABLE statement. Restore data may be failed.
- Type conversion for the column X may fail because the data may be inconsistent.
- Data in column X will be lost as it is incompatible with a new data type.
- System versioning data will be lost.
- Cannot restore data for column X, because data type is inconsistent.
- Cannot restore data.
- Possible data loss in the column X when converting from type Y to Z.
Warnings related to constraints and default values
- Default value should be set in the correct format for X data type.
- Adding NOT NULL constraint.
- Adding NOT NULL constraint may fail if the table is not empty.
- NOT NULL constraint will not be set.
- Default value cannot be empty. Please specify default value in correct data format.
Warnings related to data update
- Data update.
- The auto-generated default value X will be inserted into the new column Y in the table Z.
Warnings related to the loss of privileges and permissions
- Possible privileges loss.
- Some object permissions can be lost if the granted objects will not be synchronized.
Other warnings
- The script may fail.
- Table rebuild required.
- The column X of the table Y is less tinyint precision in the source than in the target.
- XY has inessential distinction.
- Ignore Partition option was enabled.
- The Ignore Partitions option was turned on. The table X will be recreated. Check that changing object structure does not conflict with partitioning settings.