documentation/Reference/Configuration/Redgate Compare Namespace/Redgate Compare SQL Server Namespace/SQL Server Ignore Options Namespace.md
This namespace contains the configurations relating to the database features/syntax to track when running SQL Server database comparisons.
| Setting | Type | Description |
|---|---|---|
ignoreAuthorizationOnSchemaObjects | Boolean | Ignore authorization clauses on schema-qualified objects when comparing and deploying databases. |
ignoreBindings | Boolean | Ignore bindings on columns and user-defined types when comparing and deploying databases. |
ignoreChangeTracking | Boolean | Ignore change tracking when comparing and deploying databases. |
ignoreCollations | Boolean | Ignore collations on character data type columns when comparing and deploying databases. |
ignoreComments | Boolean | Ignore comments when comparing views, stored procedures, and other objects. |
ignoreDataCompression | Boolean | Ignore page and row compression when comparing tables and indexes. |
ignoreDataSyncSchema | Boolean | Ignore all objects contained in a schema called DataSync. |
ignoreDatabaseAndServerNameInSynonyms | Boolean | Ignore the database and server name in synonyms when comparing databases. |
ignoreDmlTriggers | Boolean | Ignore DML triggers when comparing and deploying databases. |
ignoreDynamicDataMasking | Boolean | Ignore MASKED clauses on table columns. |
ignoreEventNotificationsOnQueues | Boolean | Ignore the event notification on queues when comparing and deploying databases. |
ignoreExtendedProperties | Boolean | Ignore extended properties on objects and databases when comparing and deploying databases. |
ignoreFileGroupsPartitionSchemesAndPartitionFunctions | Boolean | Ignore filegroup clauses, partition schemes and partition functions on tables and keys when comparing and deploying databases. |
ignoreFillFactorAndIndexPadding | Boolean | Ignore the fill factor and index padding in indexes and primary keys when comparing and deploying databases. |
ignoreFullTextIndexing | Boolean | Ignore full-text catalogs and full-text indexes when comparing and deploying databases. |
ignoreIdentitySeedAndIncrementValues | Boolean | Ignore identity seed and increment values when comparing and synchronizing databases. |
ignoreIndexes | Boolean | Ignore indexes, unique constraints and primary keys when comparing and deploying databases. |
ignoreInsteadOfTriggers | Boolean | Ignore INSTEAD OF DML triggers when comparing and deploying databases. |
ignoreInternallyUsedMicrosoftExtendedProperties | Boolean | Ignore the extended properties used internally by the SSMS designer when comparing and deploying databases. |
ignoreLockPropertiesOfIndexes | Boolean | Ignore index PAGE LOCK and ROW LOCK properties when comparing and deploying databases. |
ignoreNocheckAndWithNocheck | Boolean | Ignore the NOCHECK and WITH NOCHECK arguments on foreign keys and check constraints. |
ignoreNotForReplication | Boolean | Ignore the NOT FOR REPLICATION property in foreign keys, identities, check constraints and triggers. |
ignoreNullabilityOfColumns | Boolean | Ignore whether or not a column can allow NULL values. |
ignorePerformanceIndexes | Boolean | Ignore everything that the 'Ignore indexes' option ignores except primary keys and unique constraints. |
ignorePermissions | Boolean | Ignore permissions on objects when comparing and deploying databases. |
ignoreReplicationTriggers | Boolean | Ignore replication triggers when comparing and deploying databases. |
ignoreSchemas | Boolean | Ignore schemas when comparing and deploying databases. |
ignoreSensitivityClassifications | Boolean | Ignore fields' sensitivity classifications when comparing and deploying databases. |
ignoreSetQuotedIdentifierAndSetAnsiNullsStatements | Boolean | Ignore these SET statements when comparing views, stored procedures, and other objects. |
ignoreSquareBracketsInObjectNames | Boolean | Ignore starting and ending square bracket in object names which have been escaped using square brackets. |
ignoreStatistics | Boolean | Ignore statistics when comparing and deploying databases. |
ignoreStatisticsIncremental | Boolean | Ignore Statistics Incremental during comparison. |
ignoreStatisticsNoRecomputePropertyOnIndexes | Boolean | Ignore the STATISTICS_NORECOMPUTE option on indexes and primary keys. |
ignoreSynonymDependencies | Boolean | Ignore the names of system named indexes, foreign keys, primary keys, and default, unique, and check constraints. |
ignoreSystemNamedConstraintAndIndexNames | Boolean | Ignore the names of system named indexes, foreign keys, primary keys, and default, unique, and check constraints when comparing fields in views, tables and table-valued types. |
ignoreTsqltFrameworkAndTests | Boolean | Ignore the tSQLt schema and its contents, the tSQLt CLR assembly, the SQLCop schema and its contents, and any schemas and their contents with the tSQLt.TestClass extended property set. |
ignoreUserProperties | Boolean | Ignore users' properties. |
ignoreUsersPermissionsAndRoleMemberships | Boolean | Ignore users' permissions and role memberships. |
ignoreWhiteSpace | Boolean | Ignore whitespace (e.g. newlines, tabs, spaces) when comparing databases. |
ignoreWithElementOrder | Boolean | Ignore the order of WITH elements when comparing and deploying databases. |
ignoreWithEncryption | Boolean | Ignore WITH ENCRYPTION statements on triggers, views, stored procedures and functions. |
ignoreWithNoCheck | Boolean | Ignore the WITH NOCHECK argument on foreign keys and check constraints. |