Redgate Flyway

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

Settings

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.

Redgate Flyway

SQL Server Ignore Options Namespace

Settings