4.3.21300 - October 27th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.9.20033

4.3.21293 - October 20th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.8.20020

Fixes:

• VT-116 - Fixed problem with parsing Sqlcmd variables applied inside scripts.

4.3.21284 - October 12th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.7.19971

4.3.21279 - October 6th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.7.19960

4.3.21271 - September 29th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.6.19929

4.3.21264 - September 22nd, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.5.19868

4.3.21259 - September 16th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.3.19789

4.3.21251 - September 9th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.2.19672

4.3.21244 - September 1st, 2021

Fixes:

• VT-99 Octopus Deploy *.json files update
  redgate-deploy-from-database.json in now version 37
  redgate-deploy-from-database-release.json is now version 18
  redgate-deploy-from-package.json is now version 18

Improvements:

• Internal library updates

4.3.21236 - August 24th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.1.19638

4.3.21230 - August 18th, 2021

Improvements:

• Updated SQL Compare Engine to 14.6.0.19628

4.3.21224 - August 12th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.21.19562

Fixes:

• VT-82 - Added new option FailBuildOnParseErrors, to force stop project verification in Power Shell, if parser failed to validate the scripts.

4.3.21216 - August 5th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.21.19536

4.3.21210 - July 29th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.20.19531

4.3.21202 - July 22nd, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.18.19503

4.3.21195 - July 14th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.17.19404

4.3.21187 - July 7th, 2021

Improvements:

• VT-7 - Project verification errors will now be considered warnings, allowing the build/deployment to continue even if TransactSql.ScriptDom parser failed to validate the scripts.
• Updated SQL Compare Engine to 14.5.16.19384

4.3.21181 - June 30th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.14.19353

4.3.21174 - June 24th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.14.19325

4.3.21167 - June 16th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.13.19295

4.3.21160 - June 9th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.12.19214

4.3.21152 - June 2nd, 2021

Improvements:

• VT-61 - RGTEMP environment variable can now be used to override temporary directory path used by SQL Change Automation.
• Updated SQL Compare Engine to 14.5.10.19205

4.3.21147 - May 27th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.10.19177

4.3.21139 - May 20th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.8.19095

Fixes:

• VT-28 - Register-SqlChangeAutomation cmdlet has been deprecated and is no longer available. "Functionality has been discontinued" message will be shown if usage is attempted. For licensing information, please see https://documentation.red-gate.com/sca/getting-started/licensing.

4.3.21132 - May 12th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.8.19078

4.3.21125 - May 5th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.6.18966

4.3.21118 - April 28th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.6.18850

Fixes:

• VT-46 - Using "Azure Active Directory - Password" authentication method should no longer cause "The server terminated an operation because it encountered a client request loop." exception.

4.3.21108 - April 19th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.4.18838

4.3.21098 - April 8th, 2021

Fixes:

• VT-25 - Drift preservation script (NEW INCREMENTAL MIGRATIONS section in DriftRevertScript.sql) now contains statements opposite to the ones from drift reversion script.

4.3.21089 - March 30th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.3.18679

4.3.21084 - March 25th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.3.18653

4.3.21076 - March 17th, 2021

Improvements:

• Updated SQL Compare Engine to 14.5.2.18565

Fixes:

• VT-14 - Invoke-DatabaseBuild cmdlet's schema validation will now fail as expected if potential cross-database object/data modification was detected.

4.3.21069 - March 11th, 2021

Features:

• VT-22: Modification of the information text about the license.

4.3.21062 - March 3rd, 2021

Improvements:

• Updated SQL Compare Engine to 14.4.24.18416

4.3.21056 - February 25th, 2021

Improvements:

• Updated SQL Compare Engine to 14.4.24.18359

4.3.21048 - February 17th, 2021

Improvements:

• Updated SQL Compare Engine to 14.4.22.18256

4.3.21041 - February 11th, 2021

Improvements:

• Updated SQL Compare Engine to 14.4.22.18208

4.3.21029 - February 1st, 2021

Improvements:

• Updated SQL Compare Engine to 14.4.20.18129

4.3.21020 - January 20th, 2021

Improvements:

• Updated SQL Compare Engine to 14.4.19.17961

4.3.21013 - January 13th, 2021

Fixes:

• Fixed issue where the extension may fail to install from PowerShell Gallery

4.3.21012 - January 13th, 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 8th, 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 17th, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.16.17662

4.3.20343 - December 9th, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.15.17568

4.3.20336 - December 1st, 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 19th, 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 22nd, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.9.17023

4.3.20288 - October 15th, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.7.16960

4.3.20280 - October 6th, 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 28th, 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 23rd, 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 16th, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.3.16779

4.3.20259 - September 15th, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.3.16730

4.3.20252 - September 8th, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.2.16694

4.3.20247 - September 3rd, 2020

Improvements:

• Updated SQL Compare Engine to 14.4.2.16668

4.3.20234 - August 21st, 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 11th, 2020

Improvements:

• Updated SQL Compare Engine to 14.3.4.16560

4.3.20211 - July 29th, 2020

Improvements:

• Updated SQL Compare Engine to 14.3.2.16499

4.3.20205 - July 23rd, 2020

Improvements:

• Updated SQL Compare Engine to 14.3.1.16483