Back to Flyway

SQL Server Ignore Options Namespace

documentation/Reference/Configuration/Redgate Compare Namespace/Redgate Compare SQL Server Namespace/SQL Server Ignore Options Namespace.md

latest19.7 KB
Original Source

This namespace contains the configurations relating to the database features/syntax to track when running SQL Server database comparisons.

Settings

SettingTypeDescription
ignoreAuthorizationOnSchemaObjectsBooleanIgnore authorization clauses on schema-qualified objects when comparing and deploying databases.
ignoreBindingsBooleanIgnore bindings on columns and user-defined types when comparing and deploying databases.
ignoreChangeTrackingBooleanIgnore change tracking when comparing and deploying databases.
ignoreCollationsBooleanIgnore collations on character data type columns when comparing and deploying databases.
ignoreCommentsBooleanIgnore comments when comparing views, stored procedures, and other objects.
ignoreDataCompressionBooleanIgnore page and row compression when comparing tables and indexes.
ignoreDataSyncSchemaBooleanIgnore all objects contained in a schema called DataSync.
ignoreDatabaseAndServerNameInSynonymsBooleanIgnore the database and server name in synonyms when comparing databases.
ignoreDmlTriggersBooleanIgnore DML triggers when comparing and deploying databases.
ignoreDynamicDataMaskingBooleanIgnore MASKED clauses on table columns.
ignoreEventNotificationsOnQueuesBooleanIgnore the event notification on queues when comparing and deploying databases.
ignoreExtendedPropertiesBooleanIgnore extended properties on objects and databases when comparing and deploying databases.
ignoreFileGroupsPartitionSchemesAndPartitionFunctionsBooleanIgnore filegroup clauses, partition schemes and partition functions on tables and keys when comparing and deploying databases.
ignoreFillFactorAndIndexPaddingBooleanIgnore the fill factor and index padding in indexes and primary keys when comparing and deploying databases.
ignoreFullTextIndexingBooleanIgnore full-text catalogs and full-text indexes when comparing and deploying databases.
ignoreIdentitySeedAndIncrementValuesBooleanIgnore identity seed and increment values when comparing and synchronizing databases.
ignoreIndexesBooleanIgnore indexes, unique constraints and primary keys when comparing and deploying databases.
ignoreInsteadOfTriggersBooleanIgnore INSTEAD OF DML triggers when comparing and deploying databases.
ignoreInternallyUsedMicrosoftExtendedPropertiesBooleanIgnore the extended properties used internally by the SSMS designer when comparing and deploying databases.
ignoreLockPropertiesOfIndexesBooleanIgnore index PAGE LOCK and ROW LOCK properties when comparing and deploying databases.
ignoreNocheckAndWithNocheckBooleanIgnore the NOCHECK and WITH NOCHECK arguments on foreign keys and check constraints.
ignoreNotForReplicationBooleanIgnore the NOT FOR REPLICATION property in foreign keys, identities, check constraints and triggers.
ignoreNullabilityOfColumnsBooleanIgnore whether or not a column can allow NULL values.
ignorePerformanceIndexesBooleanIgnore everything that the 'Ignore indexes' option ignores except primary keys and unique constraints.
ignorePermissionsBooleanIgnore permissions on objects when comparing and deploying databases.
ignoreReplicationTriggersBooleanIgnore replication triggers when comparing and deploying databases.
ignoreSchemasBooleanIgnore schemas when comparing and deploying databases.
ignoreSensitivityClassificationsBooleanIgnore fields' sensitivity classifications when comparing and deploying databases.
ignoreSetQuotedIdentifierAndSetAnsiNullsStatementsBooleanIgnore these SET statements when comparing views, stored procedures, and other objects.
ignoreSquareBracketsInObjectNamesBooleanIgnore starting and ending square bracket in object names which have been escaped using square brackets.
ignoreStatisticsBooleanIgnore statistics when comparing and deploying databases.
ignoreStatisticsIncrementalBooleanIgnore Statistics Incremental during comparison.
ignoreStatisticsNoRecomputePropertyOnIndexesBooleanIgnore the STATISTICS_NORECOMPUTE option on indexes and primary keys.
ignoreSynonymDependenciesBooleanIgnore the names of system named indexes, foreign keys, primary keys, and default, unique, and check constraints.
ignoreSystemNamedConstraintAndIndexNamesBooleanIgnore 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.
ignoreTsqltFrameworkAndTestsBooleanIgnore 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.
ignoreUserPropertiesBooleanIgnore users' properties.
ignoreUsersPermissionsAndRoleMembershipsBooleanIgnore users' permissions and role memberships.
ignoreWhiteSpaceBooleanIgnore whitespace (e.g. newlines, tabs, spaces) when comparing databases.
ignoreWithElementOrderBooleanIgnore the order of WITH elements when comparing and deploying databases.
ignoreWithEncryptionBooleanIgnore WITH ENCRYPTION statements on triggers, views, stored procedures and functions.
ignoreWithNoCheckBooleanIgnore the WITH NOCHECK argument on foreign keys and check constraints.