SQL Change Automation 4

SQL Change Automation SSMS 4.3 release notes

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.21259 - September 16th, 2021

Fixes:

  • VT-100 - SqlCmdVariables value defined as $(SqlCmdVar__X) is now evaluated from '.sqlproj.user' file - the same way as in Visual Studio.

4.3.21251 - September 8th, 2021

Improvements:

  • Updated SQL Compare Engine to 14.6.2.19672

Fixes:

  • VT-79 - Fixed issue where dropping extended property of programmable object scripted as CREATE OR ALTER caused generation of invalid script.
  • VT-87 - Fixed issue where updating value of extended property caused generation of invalid script.

4.3.21244 - September 1st, 2021

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.19569

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

Fixes:

  • VT-78 - Fixed extended properties of programmable objects not being idempotent unless the object itself was changed.

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

Fixes:

  • VT-76 - Fixed issue where creation of extended properties of programmable objects would not be scripted as idempotent for certain types of values.

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 23rd, 2021

Improvements:

  • Updated SQL Compare Engine to 14.5.14.19325

Fixes:

  • VT-70 - Fixed non-idempotent extended properties for programmable objects with multiline string parameters.

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

Fixes:

  • VT-67 - Added link to help page to warning text that migration may fail when user chooses to migrate External Data Source with credentials.
  • VT-30 - Fixed parsing of sql scripts to include the CONNECTION_OPTIONS clause in External Data Source objects.

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

Fixes:

  • VT-51 - Fixed idempotent extended properties for programmable objects inside "Create or change" script.

4.3.21139 - May 19th, 2021

Improvements:

  • Updated SQL Compare Engine to 14.5.8.19095

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

Features:

  • VT-31 - Added warning about migration possibly failing when user selects to migrate External Data Source with credentials.

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.
  • VT-50 - Database loading fix during verification SCA project based on an SQL Source Control project as a development source.

4.3.21108 - April 19th, 2021

Improvements:

  • Updated SQL Compare Engine to 14.5.4.18838

4.3.21098 - April 12th, 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

4.3.21069 - March 10th, 2021

Fixes:

  • VT-13 - Fixed Legacy Programmable Objects setting being replaced automatically.

4.3.21062 - March 3rd, 2021

Improvements:

  • Updated SQL Compare Engine to 14.4.24.18416

Features:

  • VT-11: When creating a project with baseline, readme.txt with short description on how folder structure can be customized will be generated in the 1.1.0-Changes directory.

Fixes:

  • VT-3 - Fixed error while generating the migration screen.

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 10th, 2021

Improvements:

  • Updated SQL Compare Engine to 14.4.22.18208

4.3.21026 - January 26th, 2021

Improvements:

  • Updated SQL Compare Engine to 14.4.19.18070

Fixes:

  • SCA-2780 - Setting SyncOptionUseDropCreateInsteadOfAlter to true via the UI now automatically sets SyncOptionIncludeExistenceChecks to true, as documented

4.3.21020 - January 20th, 2021

Improvements:

  • Updated SQL Compare Engine to 14.4.19.17961

Fixes:

  • SCA-2781 - Fixed error during filtering on migrations screen

4.3.21012 - January 12th, 2021

Improvements:

  • Updated SQL Compare Engine to 14.4.18.17851

4.3.20352 - December 17th, 2020

Features:

  • SCA-2778 - Added filtering to the Generate Migrations page

Improvements:

  • Improved performance of the Generate Migrations page when there is a large number of differences
  • Updated SQL Compare Engine to 14.4.16.17662

4.3.20342 - December 8th, 2020

Improvements:

  • Updated SQL Compare Engine to 14.4.15.17555

4.3.20336 - December 1st, 2020

Improvements:

  • Updated SQL Compare Engine to 14.4.14.17499

4.3.20330 - November 25th, 2020

Improvements:

  • Updated SQL Compare Engine to 14.4.12.17429

Features:

  • SCA-2768 - The project SQLDSP version is now set from the target database during baseline

Fixes:

  • SCA-2771 - Prevented duplicate script references from being added to the project file

4.3.20324 - November 19th, 2020

Improvements:

  • Updated SQL Compare Engine to 14.4.12.17385

Fixes:

  • SCA-2774 - The default provisioning script now encloses the database name in square brackets, to prevent incorrect syntax errors

4.3.20316 - November 11th, 2020

Improvements:

  • SCA-2761 - Reduced the comment length when generating offline schema model files

4.3.20309 - November 4th, 2020

Improvements:

  • SCA-2762 - The default CreateDatabase.sql script, used to provision development or shadow databases, will now create Azure DB as BASIC edition by default for new projects. This file can be customised to tweak this behaviour.
  • Updated SQL Compare Engine to 14.4.10.17208

4.3.20295 - October 21st, 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

Features:

  • Added an action for creating a zip file of the most recent logs to the help menu (share log files).

Fixes:

  • SCA-2764 - Shadow now correctly rebuilds when there are applied migrations in the shadow database, and no migrations on disk.

4.3.20272 - September 28th, 2020

Improvements:

  • Updated SQL Compare Engine to 14.4.5.16843

4.3.20267 - September 23rd, 2020

Improvements:

  • Verify now updates the offline schema model. This allows the offline schema model to be updated correctly following a manual edit or deletion of a migration script.

Features:

  • Added the ability to configure the shadow database location from the project setup wizard
  • The offline schema model will now be generated on project creation when using a SQL Source Control project as a development source and a SQL Clone image as a baseline

Fixes:

  • SCA-2746 - Removed some comparisons options from the UI which cannot be configured in SQL Change Automation

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

Fixes:

  • Fix issue when using a scripts folder as data source during project setup

4.3.20246 - September 2nd, 2020

Improvements:

  • Updated SQL Compare Engine to 14.4.2.16668

4.3.20238 - August 25th, 2020

Improvements:

  • Added comment to offline schema model scripts to help explain how to use them

4.3.20233 - August 20th, 2020

Improvements:

  • Updated SQL Compare Engine to 14.3.5.16614

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.20209 - July 27th, 2020

Improvements:

  • Updated SQL Compare Engine to 14.3.1.16487

4.3.20205 - July 23rd, 2020

Improvements:

  • Updated SQL Compare Engine to 14.3.1.16483

Features:

  • It is now possible to use a SQL Clone image in place of a database for baselining. For more information, see the documentation.
  • The offline schema model scripts are now generated when using a SQL Clone image as baseline. This behavior is not yet available for projects based on a SQL Source Control scripts folder.
  • Added new project setting ProgrammableObjectHandling which replaces existing setting DeployChangesForProgrammableObjects Any existing projects which contain DeployChangesForProgrammableObjects will have the new setting added. The old setting will not be removed automatically as that might break continuous integration pipelines using older versions of the product. The new setting has three values:
  • ScriptInMigrations - Equivalent to previous false behaviour. i.e. no programmable objects
  • UseRepeatableScriptsForAllObjects - Equivalent to previous true behaviour. i.e. all programmable objects scripted out at baseline and thereafter
  • UseRepeatableScriptsForModifiedObjects - Programmable objects are scripted out in the offline schema model during baseline, but to the programmable objects folder thereafter. When an object is scripted to the programmable objects folder, it is removed from the offline schema model folder.
  • The apply screen can now be used to provision a new development database, using the specified connection details and configured provisioner
  • It is now possible to create down scripts alongside migration scripts by creating files prefixed with U_. These will not show up in the UI.
  • It is now possible to provision a new development database using SQL Clone during project setup using the New database option
  • It is no longer necessary to specify the SkipBaselineCheck property when a provisioner is configured

Changes:

  • Selecting New database as a development source will no longer immediately create a blank database. A new database will either be provisioned during project setup or from the apply screen using the configured provisioner.

Fixes:

  • Opening a project with a development database which is configured but doesn't exist now navigates to the apply page

Didn't find what you were looking for?