Page History
...
Schema Synchronization will show you this tab only when the target column name does not match the source column name.
To resolve this issue, you can perform any of these actions.
- Map the target column with the source column and prevent data loss.
- Drop the target column from the deployment script.
Map Target Column with the Source Column
...
From the Source Column, if you drop the target column then Schema Synchronization will generate a Column dropped warning, which means, Schema Synchronization will drop the column from the target table.
When you execute the deployment script, Schema Synchronization drops that column from the target table.
...
This table shows the severity for each warning that can affect the deployment script and the action you can take to resolve them.
...
You can retain the data conversion function generated by Schema Synchronization or specify a new data conversion function for the target column. Schema Synchronization will generate a Possible data truncation warning in the Warnings tab. This warning means if the data type length of the target column exceeds the source column then there is a possibility of data truncation from the target column.
...
If you choose the Ignore issue option, Schema Synchronization will add the target column name in the deployment script, instead of the data conversion function and will generate a Data will be truncated warning in the Warnings tab. This warning means if the data type length of the target column exceeded the data type length of the source column, data in the target column might be lost.
...
You can retain the data conversion function generated by Schema Synchronization or specify a new data conversion function for the target column. Schema Synchronization will generate an Ensure data is in the correct format warning in the Warnings tab. This warning means if data in the target column is not compatible with the data type of the source column, then the deployment script might fail.
...
If you choose the Ignore issue option, Schema Synchronization will add the target column name in the deployment script, instead of the data conversion function and will generate anEnsure data is in the correct format warning in the Warnings tab. This warning means if data in the target column is not compatible with the data type of the source column, then the deployment script might fail.
When you execute the deployment script, the following happens:
...
You can specify a custom value for a NOT NULL column. Schema Synchronization will add this custom value as the default value for a NOT NULL column in the deployment script and will display a Default value will be added warning in the Warnings tab. This warning means the specified custom value will be added to a NOT NULL column.
When you compare the source and the target schemas and view the schema compare result, the objects will still be displayed in a different state because the default value was added to the target column.
...
If you choose the Ignore issue option, Schema Synchronization will add NOT NULL for the target column and will add no value for this column in the deployment script and will display a No value specified for a NOT NULL column warning in the Warnings tab. This warning means no value is specified for the NOT NULL column.
When you execute the deployment script, the deployment script will fail only if the NULL column in the target database contains a NULL value.
...