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.
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.
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.
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. |