4.2.20196 - July 14, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.20.16386

Fixes:

• SCA-2725 - Fixed error publishing to Octopus Deploy NuGet server

4.2.20189 - July 7, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.19.16320

4.2.20183 - July 1, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.18.16251

Fixes:

• SCA-2725 - Fixed issue publishing to NuGet feed
• SCA-2734 - Fixed pre-login handshake database connection issue
• SCA-2735 - Fixed poor performance when building SQL Source Control projects with debug output enabled

4.2.20177 - June 25, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.18.16247
• Module files are now signed, so the module can be used when PowerShell execution policy is set to 'Restricted'

Features:

• Added a new cmdlet, Get-DependentProjectPaths, which given a solution folder will return the SQL Change Automation projects in build order

4.2.20176 - June 24, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.18.16218

4.2.20167 - June 15, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.17.16086

4.2.20161 - June 9, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.17.16043

Features:

• Added DriftHandling parameter to Use-DatabaseReleaseArtifact which provides the ability to execute the drift revert script against the target database when set to RevertOnly or RevertAndDeploy

4.2.20154 - June 2, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.16.15991

Features:

• Added support for Azure Active Directory password authentication for SQL Source Control projects, via the new Authentication parameter for New-DatabaseConnectionCommand

Fixes:

• SCA-2624 - Removed 20 character limit on NuGet package version prerelease tag in New-DatabaseBuildArtifact cmdlet
• SCA-2687 - SQLClr dependencies will now be resolved when using New-DatabaseProjectObject on a project which has already been built.
• SCA-2717 - Fixed "Cannot access closed stream" error which might occur when generating large NuGet packages as part of Export-DatabaseBuildArtifact
• SCA-2722 - Failure to clean temporary database during Invoke-DatabaseBuild now treated as an error
• SCA-2724 - Fixes error during pre-deployment schema check when deploying to a target database which needs to be created

4.2.20147 - May 26, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.15.15905

Features:

• Added support for Azure Active Directory password authentication for SQL Change Automation projects, via the new Authentication parameter for New-DatabaseConnectionCommand

4.2.20140 - May 19, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.15.15842

4.2.20133 - May 12, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.14.15791

Features:

• Made it possible to use Azure SQL Server managed instance for temporary database
• New projects now use the custom provisioning scripts feature by default.
  Logic for creating a database is now located in a CreateDatabase.sql script inside the Provisioning folder, instead of in a placeholder pre-script.
  This allows the temporary database used during the build step to be located on an Azure instance.
  The default CreateDatabase.sql and DropDatabase.sql scripts can be altered to improve performance or implement custom provisioning logic.
  Note that this will likely be necessary to improve performance if the temporary database is located on Azure.

4.2.20127 - May 6, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.13.15750

4.2.20119 - April 28, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.11.15576

4.2.20112 - April 21, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.10.15551

4.2.20106 - April 15, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.9.15498

Fixes:

• SCA-2676 - Errors during NuGet package generation now cause build failures
• SCA-2703 - Removed build warning about using default TraceLogger

4.2.20098 - April 7, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.9.15488

• Updated the temporary database name prefix from dlmautomation_ to sql_change_automation_

4.2.20091 - March 31, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.8.15435

4.2.20085 - March 25, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.6.15402

4.2.20078 - March 18, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.6.15379

Fixes:

• SCA-2695 - Fixed a bug where comparison reports generated by Export-DatabaseReleaseArtifact
  would render incorrectly scripts containing lowercase AS

4.2.20064 - March 4, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.4.15307

4.2.20058 - February 27, 2020

Improvements:

• Additional detailed logging for SQL Change Automation project build process

4.2.20056 - February 25, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.3.15157

4.2.20050 - February 19, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.2.15114

4.2.20043 - February 12, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.1.15027

4.2.20035 - February 4, 2020

Fixes:

• SCA-2672 - Improved logic for selecting the most recent sqlcmd version when deploying SQL Change Automation projects

4.2.20030 - January 31, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.1.14869

4.2.20022 - January 22, 2020

Improvements:

• Updated SQL Compare Engine to 14.1.10.14743