Default SQL Compare options used by SQL Release
Published 11 November 2014
By default, SQL Release uses the SQL Compare options indicated below.
The table also show the default SQL Compare options used by SQL Source Control. SQL Compare options used in Source Control are ignored by SQL Release.
| SQL | Source |
|---|---|---|
✔ | ✔ | |
| DecryptPost2KEncryptedObjects | ✔ | ✔ |
✖ | ✔ | |
✔ | ✔ | |
✔ | ✔ | |
✔ | ✔ | |
| IgnoreDatabaseAndServerName | ✔ | ✔ |
* ✔ * | ✖ | |
✔ | n/a | |
| IgnoreUserProperties | ✔ | ✔ |
| IgnoreWhiteSpace | ✔ | ✔ |
| IgnoreWithElementOrder | ✔ | ✔ |
✔ | ✖ | |
✔ | ✔ | |
| UseCompatibilityLevel | ✔ | n/a |
** ✔ ** | ✖ |
* By default, the Invoke-DlmDatabaseSchemaValidation and Invoke-DlmDatabaseTests cmdlets don't use the IgnoreTSQLT Compare option.
** By default, the Invoke-DlmDatabaseSchemaValidation and Invoke-DlmDatabaseTests cmdlets don't support the UseMigrationsV2 Compare option.
