Configure comparison options

You can use project options to configure the behavior of Schema Compare.

When you create a new project, you should run the comparison with the default options, then review your comparison results. After you have reviewed your comparison results, you may want to consider changing some of the options. The options you set are saved for each project, and you can modify them on the Options tab of the New Schema Comparison wizard.

Options wizard

If you click Save Command Line, the Command Line Wizard will get opened.

Default options

If you want to make the current selection of options your defaults, click Save As My Defaults. These options will be used for all new projects.

To restore your defaults after making changes, click My Defaults.

Save as defaults

If you need to reset all the options to their original settings, click Devart Defaults.

For convenience, options are grouped and there is a detailed description for each option.

Options groups

To search for an option, type the search text in the Search box. The list is filtered to display only those options that contain the search text.

List of schema comparison options

Option name Option Group Default State Option Description
Associate column names having similar name options, 80 % Auto Mapping No Identifies similar column names to be equal.
Ignore case in object names Auto Mapping No Ignores cases in object names during mapping and comparison.
Ignore spaces in object names Auto Mapping No Ignores spaces in object names during mapping and comparison.
Compare database properties Common Yes Includes a database object in the comparison and synchronization.
Convert user data types into SQL Server system data types Common No Transforms user data types into SQL Server system data types during the database comparison and synchronization.
Disable dependency analysis Common No Disables dependency building algorithms and describes object types selected in the Object filter.
Ignore authorization Common No Ignores the AUTHORIZATION clauses and statements on the contained database objects during the database comparison and synchronization.
Ignore CHANGE_TRACKING Common No Ignores the CHANGE_TRACKING clauses during the database comparison and synchronization.
Ignore CLR datatypes in column Common No Ignores CLR datatypes in the column during the database comparison and synchronization.
Ignore collations Common No Ignores column collations during the database comparison and synchronization.
Ignore DATA_COMPRESSION for tables, indexes, primary and unique constraints Common Yes Ignores the DATA_COMPRESSION clause for tables, indexes, primary and unique constraints.
Ignore database and server names for synonyms Common Yes Ignores database and server names for synonyms during the database comparison and synchronization.
Ignore database extended properties Common Yes Ignores extended properties of the database during the database comparison and synchronization.
Ignore database object extended properties Common No Ignores extended properties of the database object during the database comparison and synchronization.
Ignore datatypes in column Common No Ignores datatypes in the column during the database comparison and synchronization.
Ignore event notification on queues Common No Ignores an event notification on queues during the database comparison and synchronization.
Ignore filegroups and partition schemes/functions Common No Ignores filegroups, partition schemes, and partition functions during the database comparison and synchronization.
Ignore full-text catalog path Common No Ignores the path in the full-text catalog during the database comparison and synchronization.
Ignore full-text search Common No Ignores full-text stoplists, full-text catalogs, and full-text indexes during the database comparison and synchronization.
Ignore next filegroups Common No Ignores next filegroups during the database comparison and synchronization.
Ignore semicolons Common No Ignores semicolons at the end of statements during the database comparison and synchronization.
Ignore sequence max value Common No Ignores the sequence maximum value.
Ignore sequence min value Common No Ignores the sequence minimum value.
Ignore sequence start value Common No Ignores the sequence start value.
Ignore tSQLt framework and unit tests Common No Excludes objects of the tSQLt framework and unit tests during the database comparison and synchronization.
Ignore user DEFAULT_SCHEMA Common Yes Ignores DEFAULT_SCHEMA for users during the database comparison and synchronization.
Ignore permissions Common No Ignore security permissions during the database comparison and synchronization.
Ignore users’ permissions Common No Ignores users’ permissions and roles memberships during the database comparison and synchronization.
Ignore user DEFAULT_LANGUAGE Common No Ignores DEFAULT_LANGUAGE for users during the database comparison and synchronization.
Ignore logins, certificates, asymmetric keys for users Common Yes Ignores logins, certificates, and asymmetric keys, and synchronizes the corresponding user properties.
If you want to ignore users, first, you need to configure the Object Filter after the comparison as described in the Use object filter topic.
Populate full-text indexes Common No Populates full-text indexes.
Quote object names with square brackets Common Yes Quotes object names with square brackets during the script generation.
Force column order Tables Yes Forces the re-creation of the table when adding new columns to it.
Ignore bound rules and defaults Tables No Ignores bound rules and defaults during the database comparison and synchronization.
Ignore default column collations Tables Yes Ignores default column collations during the database comparison and synchronization.
Ignore history tables names Tables Yes Ignores history tables names during the database comparison and synchronization.
Ignore identity on columns Tables No Ignores identity on columns during the database comparison and synchronization.
Ignore identity seed and increment values Tables No Ignores identity seed and increment values during the database comparison and synchronization.
Ignore LOCK_ESCALATION Tables Yes Ignores LOCK_ESCALATION for tables during the database comparison and synchronization.
Ignore table DML triggers Triggers No Ignores DML triggers for tables during comparison and synchronization.
Ignore INSTEAD OF triggers Triggers No Ignores INSTEAD OF triggers for tables during comparison and synchronization.
Ignore state of DML triggers Triggers No Ignores state of DML triggers during comparison and synchronization.
Ignore state of DDL triggers Triggers No Ignores state of DDL triggers during comparison and synchronization.
Ignore firing order for DDL and DML triggers Triggers No Ignores a firing order for DDL and DML triggers.
Ignore check constraints Indexes and constraints No Ignores check constraints during comparison and synchronization.
Ignore column order in indexes Indexes and constraints No Ignores a column order for the included columns during comparison and synchronization.
Ignore constraint names Indexes and constraints No Ignores constraint names during comparison and synchronization.
Ignore constraints’ system names Indexes and constraints Yes Ignores constraint system names.
Ignore default constraints Indexes and constraints No Ignores defaul constraints and schema defaults during comparison and synchronization.
Ignore foreign key Indexes and constraints No Ignores foreign keys during comparison and synchronization.
Ignore foreign key actions ON UPDATE and ON DELETE Indexes and constraints No Ignores cascading referential integrity constraints for foreign keys during comparison and synchronization.
Ignore indexes Indexes and constraints No Ignores indexes in tables and views during comparison and synchronization.
Ignore indexes’ names Indexes and constraints No Ignores names of indexes in tables and views during comparison and synchronization.
Ignore NOCHECK state on constraints Indexes and constraints No Ignores the NOCHECK clause for foreign keys and check constraints during comparison and synchronization.
Ignore NOT NULL constraint for a column Indexes and constraints No Ignores the NOT NULL constraint for a column during comparison and synchronization.
Ignore PAD_INDEX and FILLFACTOR for indexes and constraints Indexes and constraints No Ignores PAD_INDEX and FILLFACTOR for indexes and constraints during comparison and synchronization.
Ignore PAGE_LOCK and ROW_LOCK for indexes and constraints Indexes and constraints No Ignores ALLOW_PAGE_LOCK and ALLOW_ROW_LOCK for indexes and constraints during comparison and synchronization.
Ignore primary keys Indexes and constraints No Ignores differences in primary keys during comparison and synchronization.
Ignore sort direction (ASC/DESC) for index columns Indexes and constraints No Ignores sort direction for index columns during comparison and synchronization.
Ignore statistics Indexes and constraints No Ignores statistics related to the column during comparison and synchronization.
Ignore STATISTICS_NORECOMPUTE for indexes and constraints Indexes and constraints No Ignores STATISTICS_NORECOMPUTE for indexes and constraints during comparison and synchronization.
Ignore unique keys Indexes and constraints No Ignores differences in unique keys during comparison and synchronization.
Ignore WITH NOCHECK state on constraints Indexes and constraints No Ignores WITH NOCHECK for constraints during comparison and synchronization.
Ignore DML and INSTEAD OF triggers present only in Target Keep objects in target No Ignores dropped DML triggers in target while comparing and synchronizing tables or views.
Ignore indexes present only in target Keep objects in target No Ignores dropped indexes in target while comparing and synchronizing tables or views.
Ignore NOT FOR REPLICATION for indexes, constraints and triggers Replications No Ignores NOT FOR REPLICATION for indexes, constraints, and triggers during comparison and synchronization.
Ignore replication tables Replications Yes Ignores replication tables during comparison.
Ignore replication procedures Replications No Ignores replication procedures during comparison and synchronization.
Ignore replication roles Replications No Ignores replication roles during comparison and synchronization.
Ignore replication schemas Replications No Ignores replication schemas during comparison and synchronization.
Ignore replication triggers Replications No Ignores replication triggers during comparison and synchronization.
Decrypt encrypted objects Script Objects Yes Decrypts bodies of encrypted objects for comparison and synchronization.
Ignore case Script Objects No Ignores case differences in object’s body during comparison.
Ignore comments Script Objects No Ignores comments while comparing stored procedures, views, functions, etc.
Ignore keyword reduction Script Objects Yes Ignores differences in full and short names of keywords during comparison.
Ignore object names in definitions Script Objects No Ignores object names in definitions during comparison.
Ignore QUOTED_IDENTIFIER and ANSI_NULLS Script Objects No Ignores QUOTED_IDENTIFIER and ANSI_NULLS for stored procedures, functions, triggers, etc. during comparison and synchronization.
Ignore signatures Script Objects No Ignores signatures when comparing and synchronizing stored procedures, functions, triggers, and assemblies.
Ignore white spaces Script Objects Yes Ignores white spaces (new lines, tabs, spaces, etc.) during comparison and synchronization. Original white spaces in the scripts for database objects and computed columns are preserved.
Ignore WITH ENCRYPTION Script Objects No Ignores differences in the WITH ENCRYPTION attribute during comparison and synchronization.
Ignore WITH option order Script Objects Yes Ignores elements order in the WITH clause when comparing and synchronizing stored procedures, views, triggers, functions, etc.