SQL Change Automation 4

SQL Change Automation PowerShell 4.3 release notes

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 to ScriptInMigrations

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 the New-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 of Use-DatabaseReleaseArtifactwith the value RevertAndDeploy 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

Didn't find what you were looking for?