Redgate Compare SQL Server Namespace
Published 15 January 2025
This namespace contains the SQL-Server-specific configurations relating to database comparisons and deployment script generation.
Settings
| Setting | Type | Description |
|---|---|---|
filterFile |
String | The path to your SQL Server filter file. |
Database-specific namespaces
| Namespace | Tier | Description |
|---|---|---|
data.options.comparison |
Teams | Configuration relating to SQL Server static data comparison. |
data.options.deployment |
Teams | Configuration relating to SQL Server static data deployment. |
data.options.mapping |
Teams | Configuration relating to SQL Server static data mapping. |
options.behavior |
Enterprise | Configuration relating to SQL Server database comparison and script generation behavior. |
options.ignores |
Enterprise | Configuration relating to the database features/syntax to track when running SQL Server database comparisons. |
Hard-coded options
The following options are available in Redgate SQL Compare (Flyway uses the same engine under the hood) but are hard-coded in Flyway and cannot be altered:
| Option name | Hard-coded value |
|---|---|
| AddDatabaseUseStatement | false |
| DisableAndReenableDdlTriggers | false |
| DisableAutoColumnMapping | 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 |
