Default SQL Compare options used by DLM Automation cmdlets
Published 10 March 2016
By default, the DLM Automation uses the SQL Compare options indicated below.
The table also shows the default SQL Compare options used by SQL Source Control. SQL Compare options used in Source Control are ignored by the DLM Automation cmdlets.
| DLM | 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.
