Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can retain the constant value generated by Schema Synchronization or specify a new custom value for a NOT NULL column. Schema Synchronization will add the custom value as the constant value for a NOT NULL column in the deployment script and will display a Constant value will be assigned warning in the Warnings tab. This warning means Schema Synchronization generated or a new constant value will be added for the NOT NULL column.

...

If you choose the Ignore issue option, Schema Synchronization will add the constant value of a data type in the deployment script defined by Schema Synchronization itself and will display a Constant value will be assigned warning in the Warnings tab. This warning means the constant value of a data type will be added in the deployment script. 
For both the above actions, when you execute the deployment script, data in the target column will 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 display a Column precision or data loss warning in the Warnings tab. This warning means if the data type range or the data type precision of the target column exceeded the source column then there is a possibility of deployment script failure or data loss 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 anArithmetic overflow will occur warning in the Warnings tab. This warning means if the data type range or the data type precision of the target column exceeded the data type range or the data type precision of the source column, the deployment script might fail.
When you execute the deployment script, the following happens:

...

  • If you skip this issue, Schema Synchronization does not generate the deployment script for the missing role. 
  • If you ignore this issue, you will see the Grants for missing role warning in the Warnings tab.

...

  • If you skip this issue, Schema Synchronization does not generate the deployment script for the missing user.
  • If you ignore this issue, you will see the Grants for missing user warning in the Warnings tab.

...

  • If you skip this issue, Schema Synchronization does not generate the deployment script for the missing grantee.
  • If you ignore this issue, you will see the Grants on missing grantees warning in the Warnings tab.

...

  • If you skip this issue, Schema Synchronization does not generate the deployment script for the missing group.
  • If you ignore this issue, you will see the Grants for missing group warning in the Warnings tab. 

...

Schema Synchronization will display warnings encountered while creating the deployment script. The warnings are categorized as HighMedium, and Low. You can also view the changes that Schema Synchronization will make in the script under the Summary and Detail column. You can hover the mouse on any warning in the Detail column and view the entire warning description in a tooltip. For additional information on warnings, see Schema Synchronization Warnings. Besides this, you can perform various other actions, such as searching warnings by using various search options or copying warnings to a different editor.

...