Set-up SQL Vendor Specifics

NULL values, Default values and Case sensitivity in object names are not supported by all databases; they may have different implementation in different databases and can have different configuration in the same type of database.

To inform Cross-Database software with your backend database definitions, open SQL Vendor Specifics from Tools in the main menu.

In the the SQL Vendor Specifics dialog:

Select Data Source Type – the vendor of your database.
Default values shown for each of "NULL", "NOT NULL", "DEFAULT" and naming formatting options.
If these values don’t match your database settings, select relevant value from the values list.
If you work with several databases, set Vendor specific for one database, use Apply and proceed with next database.

Note: These settings affect Migration, Comparison and Synchronization flows. See also:

Set-up Comparison options
Set-up Conversion rules
Set-up Migration options