Common parameters
Strict constraint naming
Set this option to change constraint names. Otherwise, the comparison algorithm will not recreate identical by definition but different by name constraints.
NOCHECK
Use the NOCHECK option to create Primary Keys, Foreign Keys, Check Constraints, Unique Constraints.
SORT_IN_TEMPDB
Use the SORT_IN_TEMPDB = ON option to perform operations on key-constraints and indexes whenever possible.
ONLINE
Use the ONLINE = ON option to perform operations on tables, key-constraints, and indexes whenever possible.
MAXDOP
Use the MAXDOP option to perform operations on tables, key-constraints, and indexes whenever possible.
PAD_INDEX
Set this option to change the PAD_INDEX property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
FILLFACTOR
Set this option to change the FILLFACTOR property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
IGNORE_DUP_KEY
Set this option to change the IGNORE_DUP_KEY property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
STATISTICS_INCREMENTAL
Set this option to change the STATISTICS_INCREMENTAL property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
STATISTICS_NORECOMPUTE
Set this option to change the STATISTICS_NORECOMPUTE property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
ALLOW_ROW_LOCKS
Set this option to change the ALLOW_ROW_LOCKS property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
ALLOW_PAGE_LOCKS
Set this option to change the ALLOW_PAGE_LOCKS property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
OPTIMIZE_FOR_SEQUENTIAL_KEY
Set this option to change the OPTIMIZE_FOR_SEQUENTIAL_KEY property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
BUCKET_COUNT
Set this option to change the BUCKET_COUNT property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
COMPRESSION_DELAY
Set this option to change the COMPRESSION_DELAY property of objects. Otherwise, the comparison algorithm will try to inherit these values from existing objects.
Primary Keys
Compare and synchronize Primary Keys.
Create
Create new ones, if they are not defined for the table of the target database.
Alter
Alter existing ones to remove the differences.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the table of the source database. Removal will not take place, if the table does not exist in the source database.
Unique Constraints
Compare and synchronize Unique Constraints.
Create
Create new ones, if they are not defined for the table of the target database.
Alter
Alter existing ones to remove the differences.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the table of the source database. Removal will not take place, if the table does not exist in the source database.
Drop duplicates
Drop the duplicate constraints based on their definitions.
Default Constraints
Compare and synchronize Default Constraints.
Create
Create new ones, if they are not defined for the table of the target database.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the table of the source database. Removal will not take place, if the table does not exist in the source database.
Check Constraints
Compare and synchronize Check Constraints.
Create
Create new ones, if they are not defined for the table of the target database.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the table of the source database. There is no drop performed if the table does not exist in the source database.
Drop duplicates
Drop the duplicate constraints based on their definitions.
Foreign Keys
Compare and synchronize Foreign Keys.
Create
Create new ones, if they are not defined for the table of the target database.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the table of the source database. Removal will not take place, if the table does not exist in the source database.
Drop duplicates
Drop the duplicate constraints based on their definitions.
Table Indexes
Compare and synchronize Table Indexes.
Create
Create new ones, if they are not defined for the table of the target database.
Alter
Alter existing ones to remove the differences.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the table of the source database. Removal will not take place, if the table does not exist in the source database.
Drop duplicates
Drop the duplicate constraints based on their definitions.
View Indexes
Compare and synchronize View Indexes.
Create
Create new ones, if they are not defined for the view of the target database.
Alter
Alter existing ones to remove the differences.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the view of the source database. Removal will not take place, if the view does not exist in the source database.
Drop duplicates
Drop the duplicate constraints based on their definitions.
XML Indexes
Compare and synchronize XML Indexes.
Create
Create new ones, if they are not defined for the table of the target database.
Alter
Alter existing ones to remove the differences.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they are not defined for the table of the source database. Removal will not take place, if the table does not exist in the source database.
Drop duplicates
Drop the duplicate constraints based on their definitions.