SQL Server comparison options
Published 11 October 2021
The way the changes are captured in the schema model and migration scripts can be configured using options. On the Schema model tab, click on Static data & comparisons to configure your options:
The complete list of options which can be set in Flyway can be found here.
All the options can be configured via the Flyway Desktop UI, where they are listed with a detailed description.
Each option corresponds to a setting in SQL Compare. Read more about the full list of options on our SQL Compare documentation page.
Default options
By default, the following options are set to true (and all others set to false):
- considerNextFilegroupInPartitionSchemes
- decryptEncryptedObjects
- ignoreCollations
- ignoreDataCompression
- ignoreDatabaseAndServerNameInSynonyms
- ignoreFileGroupsPartitionSchemesAndPartitionFunctions
- ignoreFillFactorAndIndexPadding
- ignoreNotForReplication
- ignoreReplicationTriggers
- ignoreStatistics
- ignoreTsqltFrameworkAndTests
- ignoreUserProperties
- ignoreUsersPermissionsAndRoleMemberships
- ignoreWhiteSpace
- ignoreWithElementOrder
- ignoreWithNoCheck
- includeDependencies
Hard-coded options (available in SQL Compare but not Flyway)
The following SQL Compare options are hard-coded in Flyway 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 |
| IgnoreTriggerOrder | false |
| NoDeploymentLogging | true |
| NoErrorHandling | true |
| NoTransactions | true |
| ThrowOnFileParseFailed | false |
