SQL Server comparison options
Published 23 March 2021
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 |
