Default SQL Compare options used by SQL Change Automation PowerShell module
Published 31 July 2019
By default, the SQL Change 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 SQL Change Automation cmdlets.
| SQL Change | Source |
|---|---|---|
✔ | ✔ | |
| DecryptPost2KEncryptedObjects | ✔ | ✔ |
✖ | ✔ | |
✔ | ✔ | |
✔ | ✔ | |
✔ | ✔ | |
| IgnoreDatabaseAndServerName | ✔ | ✔ |
* ✔ * | ✖ | |
✔ | n/a | |
| IgnoreUserProperties | ✔ | ✔ |
| IgnoreWhiteSpace | ✔ | ✔ |
| IgnoreWithElementOrder | ✔ | ✔ |
✔ | ✖ | |
✔ | ✔ | |
| UseCompatibilityLevel | ✔ | n/a |
* By default, the Invoke-DatabaseBuild and Invoke-DatabaseTests cmdlets don't use the IgnoreTSQLT Compare option.
