
Common parameters
ANSI_NULLS
If this option is not set, the comparison algorithm will ignore the ANSI_NULLS property of the objects when comparing, however, if the object is re-created due to other differences, the new value will be taken.
Stored Procedures
Compare and synchronize Stored Procedures.
Create
Create new ones, if they do not exist in the target database.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they do not exist in the source database.
Recreate All
Recreate all objects of a given type in the target database.
Scalar-Valued Functions
Compare and synchronize Scalar-Valued Functions.
Create
Create new ones, if they do not exist in the target database.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they do not exist in the source database.
Recreate All
Recreate all objects of a given type in the target database.
Table-Valued Functions
Compare and synchronize Table-Valued Functions.
Create
Create new ones, if they do not exist in the target database.
Recreate
Recreate (drop and create) existing ones to remove the differences.
Drop
Drop existing ones, if they do not exist in the source database.
Recreate All
Recreate all objects of a given type in the target database.
Table Triggers
Compare and synchronize Table Triggers.
Create
Create new ones, if they do not exist in 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.
Recreate All
Recreate all objects of a given type in the target database.
View Triggers
Compare and synchronize View Triggers.
Create
Create new ones, if they do not exist in 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 view of the source database. Removal will not take place, if the view does not exist in the source database.
Recreate All
Recreate all objects of a given type in the target database.
User Data Types
Compare and synchronize User Data Types.
Create
Create new ones, if they do not exist in the target database.
User Table Types
Compare and synchronize User Table Data Types.
Create
Create new ones, if they do not exist in the target database.