SQL Change Automation PowerShell 4.3 release notes
Published 23 July 2020
4.3.21020 - January 20, 2021
Improvements:
- Updated SQL Compare Engine to 14.4.19.17961
4.3.21013 - January 13, 2021
Fixes:
- Fixed issue where the extension may fail to install from PowerShell Gallery
4.3.21012 - January 13, 2021
Improvements:
- Updated SQL Compare Engine to 14.4.18.17874
Fixes:
- SCA-2779 - Fixed issue where the trust server certificate and encrypt settings were not being used on temporary databases for SQL Source Control projects
4.3.21008 - January 8, 2021
Improvements:
- Updated SQL Compare Engine to 14.4.17.17806
Fixes:
- SCA-2779 - Fixed issue where the trust server certificate and encrypt settings were not being used on temporary databases for SQL Change Automation projects
4.3.20352 - December 17, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.16.17662
4.3.20343 - December 9, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.15.17568
4.3.20336 - December 1, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.14.17499
Fixes:
- SCA-2775 - Addressed code analysis rule violation in static data migration scripts
4.3.20324 - November 19, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.12.17385
Fixes:
- SCA-2773 - Fixed build for projects using SQL Clone
4.3.20296 - October 22, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.9.17023
4.3.20288 - October 15, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.7.16960
4.3.20280 - October 6, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.7.16917
Fixes:
- Prevented tasks from failing when there is an issue with product metrics
4.3.20272 - September 28, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.5.16843
Fixes:
- SCA-2756 - Fixed misleading build warning when programmable scripts objects exist but
ProgrammableObjectHandling
is set toScriptInMigrations
4.3.20267 - September 23, 2020
Features:
- Added ability to set Encrypt and TrustServerCertificate connection properties on
New-DatabaseConnection
cmdlet - Added new parameter
DriftFiltering
to theNew-DatabaseReleaseArtifact
cmdlet, applicable to SQL Change Automation projects only.
Use this parameter to determine what objects should be included in the drift report
Valid options are:- 'ModifiedObjectsOnly': Include all objects which wouldn't be dropped in the drift correction script.
- 'AllObjects': Include all objects, including those which would be dropped by the drift revert script.
- 'ObjectsToBeUpdatedOnly': Only include those objects which will be updated in the current release. Dependencies are not handled.
The default setting is 'ModifiedObjectsOnly'
Fixes:
- SCA-2754 - Using The
DriftHandling
parameter ofUse-DatabaseReleaseArtifact
with the valueRevertAndDeploy
will now succeed if there was no drift to revert
4.3.20260 - September 16, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.3.16779
4.3.20259 - September 15, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.3.16730
4.3.20252 - September 8, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.2.16694
4.3.20247 - September 3, 2020
Improvements:
- Updated SQL Compare Engine to 14.4.2.16668
4.3.20234 - August 21, 2020
Improvements:
- Updated SQL Compare Engine to 14.3.5.16614
Fixes:
- SCA-2744 - Fixed logger issue caused by RemotingException on long running builds
4.3.20224 - August 11, 2020
Improvements:
- Updated SQL Compare Engine to 14.3.4.16560
4.3.20211 - July 29, 2020
Improvements:
- Updated SQL Compare Engine to 14.3.2.16499
4.3.20205 - July 23, 2020
Improvements:
- Updated SQL Compare Engine to 14.3.1.16483