Default SQL Compare options used by SQL Change Automation PowerShell module
Published 21 May 2018
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.
