Flyway Releases

Released: Feb 2, 2022

Updates in SQL Change Automation 4.4.22033

Features

  • Updated SQL Compare Engine to 14.6.17.20533.

Fixes

  • Fixed issue with manually renaming the project file and unwanted creating a new location for the opened project.

Released: Jan 26, 2022

Updates in SQL Change Automation 4.4.22026

Features

  • <ScriptsFolderPath> project property can now also be set in .sqlproj.user.
  • Updated SQL Compare Engine to 14.6.17.20470.

Released: Jan 19, 2022

Updates in SQL Change Automation 4.4.22019

Features

  • Added support for Microsoft SQL Server Aliases in SQL Server Management Studio (SSMS) plugin.
  • Updated SQL Compare Engine to 14.6.16.20427.

Released: Dec 21, 2021

Updates in Flyway Desktop 5.x

v5.17.1

Updated Dec 19, 2022

Features

  • Clean no longer runs in a transaction so objects such as memory-optimized tables for Microsoft SQL Server can now be deleted correctly.
  • Updated flyway engine to 9.10.1.
  • Updated SQL Compare engine to version 14.10.10.22784.
  • Updated Compare for Oracle engine to version 6.0.17.858.

v5.17.0

Updated Dec 9, 2022

Features

  • Added support for putting shadow databases on the same database as development for single schema databases by allow editing of shadow schema in...

Released: Dec 8, 2021

Updates in SQL Change Automation 4.4.21342

Features

  • Updated SQL Compare Engine to 14.6.13.20238.
  • Apostrophe is now escaped in SqlCmd variables value.

Fixes

  • Fixed issue where adding extended property to programmable object would cause exception to be thrown, if non-text extended property already exists on that object.
  • Fixed issue where dropping non-text extended property of programmable object would cause an exception to be thrown.

Released: Nov 24, 2021

Updates in SQL Change Automation 4.4.21327

Features

  • Updated SQL Compare Engine to 14.6.12.20146.

Fixes

  • Project verification should no longer show warnings when SQLCMD variables are used in non-text context.

Released: Nov 4, 2021

Updates in SQL Change Automation 4.4.21307

Features

  • Blocking the possibility of creating a project within an SOC project.
  • Updated SQL Compare Engine to 14.6.10.20075.

Released: Oct 6, 2021

Updates in Flyway 8.x

v8.5.13

Updated Jun 16, 2022

Fixes

  • The Ascii table will not be logged if there are no columns.
  • Fixed potential parsing bug during 'create package' statement in DB2.
  • Always close the underlying Java connection inside a Database object.

v8.5.12

Updated May 31, 2022

Features

  • The 'version' command now has JSON output.

Fixes

  • Fixed relative locations not being relative to the working directory.
  • When using the delimiter keyword the value can be placed on the next line without entering an infinite loop...

Released: Sep 16, 2021

Updates in SQL Change Automation 4.3.21259

Features

  • Updated SQL Compare Engine to 14.6.3.19789.

Fixes

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

Released: Sep 8, 2021

Updates in SQL Change Automation 4.3.21251

Features

  • Updated SQL Compare Engine to 14.6.2.19672.

Fixes

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