Table of Contents
Change Column Name Case
Defines the case of column names.
Use Constraint names of the source database
This option will use the same constraint names as in the source database. Otherwise constraint names will be skipped.
Convert default values
This option converts default values for columns. If this option is disabled, conversion of default values will be skipped.
Convert identity columns
This option converts identities. If this option is disabled, conversion of identities will be skipped.
Force NOT NULL constraints for columns that make up a primary key
This option is used to set the NOT NULL constraints in the CREATE TABLE statement for columns making up a primary key. Some databases ( Sybase, Access e.g.) allow to not specify the NOT NULL constraints for primary key columns explicitly when creating a table and change columns to NOT NULL when adding a primary key. Other databases (IBM DB2, Microsoft SQL Server, MySQL e.g.) require primary key columns to be created with NOT NULL constraints before adding a primary key.
Remove NOT NULL constraints from all columns except primary key columns
If checked, NOT NULL constraints for all columns except primary key columns in the target database will be removed.
Convert CHECK constraints
This option defines whether check constraints should be converted. If unchecked, check constraints will be skipped.
Convert Unique constraints
This option defines whether unique constraints should be converted. If unchecked, unique constraints will be skipped.
Convert cascade referential integrity constraint to no action
If checked all Foreign keys with CASCADE action would convert to Foreign Keys with NO ACTION action.
This option defines the types of the indexes that will be converted by SQLWays tool. ALL – means that all indexes will be converted. Unique – means that only unique indexes will be converted. None – means that all the indexes will not be converted.
If you have any additional questions regarding the supported options and features, please feel free to mail us: email@example.com