SQL Server comparison options
Published 29 July 2021
In v5, Redgate Change Control has been renamed to Flyway Desktop. Check out the latest documentation at https://documentation.red-gate.com/fd
The way the changes are captured in the schema model can be configured using the SQL Compare comparison options.
These can be configured in the project settings file under capabilities.comparison.options, using the option name as the key.
"capabilities": {
"comparison": {
"filter": "./Filter.scpf",
"options": {
"IgnoreUsers": false
}
}
}Default options
By default, the following options are set to true (and all others set to false):
- ConsiderNextFilegroupInPartitionSchemes
- DecryptPost2kEncryptedObjects
- IgnoreCollations
- IgnoreDatabaseAndServerName
- IgnoreDataCompression
- IgnoreFileGroups
- IgnoreFillFactor
- IgnoreNotForReplication
- IgnoreReplicationTriggers
- IgnoreStatistics
- IgnoreTSQLT
- IgnoreUserProperties
- IgnoreUsers
- IgnoreWhiteSpace
- IgnoreWithElementOrder
- IgnoreWithNocheck
- IncludeDependencies
- ThrowOnFileParseFailed
Hard-coded options
The following options are hard-coded and cannot be altered:
| Option name | Option value |
|---|---|
| AddDatabaseUseStatement | false |
| DisableAndReenableDdlTriggers | false |
DoNotOutputCommentHeader | true |
| DropAndCreateInsteadOfAlter | false |
IgnoreCertificatesAndCryptoKeys | false |
| IgnoreChecks | false |
| IgnoreConstraintNames | false |
| IgnoreIdentityProperties | false |
| IgnoreKeys | false |
| IgnoreSystemNamedConstraintNames | false |
| IgnoreTriggerOrder | false |
| NoDeploymentLogging | true |
| NoErrorHandling | true |
| NoTransactions | true |
| ThrowOnFileParseFailed | false |
