4.2.20176 - June 24th, 2020

Changes:

• Dropped support for 32-bit operating systems

Improvements:

• Updated SQL Compare Engine to 14.2.18.16218

Fixes:

• SCA-2731 - Fixed potential issue when deleting objects containing ''

4.2.20168 - June 16th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.17.16086

4.2.20161 - June 9th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.17.16043

Fixes:

• Fixed an issue when rebuilding the shadow database for new projects

4.2.20154 - June 2nd, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.16.15991

4.2.20147 - May 26th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.15.15905

4.2.20143 - May 22nd, 2020

Changes:

• Dropped support for Windows Server versions below 2012 R2. These operating systems do not support .Net Core, which will be required to keep our libraries up to date and free of security vulnerabilities.

Fixes:

• Fixed incorrect collation in default CreateDatabase.sql file for new projects

4.2.20140 - May 19th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.15.15842

Features:

• Branch creation dialogue now shows the current branch you are on.

4.2.20133 - May 12th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.14.15791

Features:

• 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 shadow database to be located on an Azure instance. Note that it is still generally recommended to locate the shadow database locally where possible as that will usually result in a faster database connection. The default CreateDatabase.sql and DropDatabase.sql scripts can be altered to improve performance or implement custom provisioning logic.

Fixes:

• Fixes issues with keyboard navigation in the dialog for selecting a database or other data source

4.2.20126 - May 5th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.13.15750

4.2.20120 - April 29th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.11.15654

Fixes:

• SC-10818: Fixes issue generating programmable objects and offline schema model when database contains triggers referencing system tables
• SCA-2715: Ensured the SQL Change Automation web server is not always launched on port 5001
• Fixed bug when selecting "No baseline" in the project setup wizard

4.2.20118 - April 27th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.11.15576

Features:

• Added UI for setting comparison options in project setup wizard.
• Added 'UseCreateOrAlterForRerunnableScripts' option for using CREATE OR ALTER for programmable objects (experimental)

Fixes:

• Fixed glitch where error notification might remain visible on the Generate Migrations page

4.2.20112 - April 21st, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.10.15551

4.2.20106 - April 15th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.9.15498

4.2.20098 - April 7th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.9.15488

Fixes:

• Fix for issue performing comparisons with SQL Server Authentication
• Fixed an issue when selecting SQL Server instance while configuring a SQL Clone development source (error message: 'Value cannot be null. Parameter name: actualServerName')

4.2.20094 - April 3rd, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.8.15461

Changes:

• ExcludeObjectsFromImport property is no longer supported. Please use Filter.scpf file instead.

Fixes:

• Fix SQL Server Authentication Server Certificate issue

4.2.20091 - March 31st, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.8.15435

Features:

• You can now undo changes to your development database on the generate migrations page (this is not available for SQL Source Control projects)
• If you specify an explicit shadow database connection string with no initial catalog, the shadow database name will continue to be derived from the development database, and respond to development database changes

4.2.20085 - March 25th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.6.15402

Features:

• Deselection of differences on the generate migrations page are now persisted across refresh, tab switching, and migration generation

Fixes:

• SCA-2704 - Fixed issue where errors raised by SQLCompare might show up as "Error while copying stream"

4.2.20078 - March 18th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.6.15379

Fixes:

• SCA-2701 - Fixed errors in development source dialog with Azure Active Directory Password authentication
• Fixed an issue where trying to create a new project was causing an error

4.2.20066 - March 6th, 2020

Features:

• You can now create a new branch from the version control page

Fixes:

• An error no longer appears when creating a development database from SQL Clone in SSMS 18

4.2.20064 - March 4th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.4.15307

Features:

• You can now switch the Git branch you are working on from the version control page

Fixes:

• SCA-2699 - Fixed incorrect behaviour when specifying a local scripts folder path and a project on a network path

4.2.20058 - February 27th, 2020

Fixes:

• Fixed an issue with development source not set warning being displayed for SQL Source control projects without a shadow database configured

4.2.20057 - February 26th, 2020

Fixes:

• Fixed an issue with SSMS getting unresponsive when choosing SQL Clone as a development source

4.2.20056 - February 25th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.3.15157

Fixes:

• Show untracked files which are not ignored as an 'add' change type on the version control page
• Fixed an issue on the version control page when viewing a repository in a conflicted state

4.2.20050 - February 19th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.2.15114
• Improved error reporting

4.2.20042 - February 11th, 2020

Improvements:

• A remote branch is now created when pushing from a new Git branch
• Updated SQL Compare Engine to 14.2.1.15027

4.2.20036 - February 5th, 2020

Fixes:

• SCA-2672 - Improved logic for selecting the most recent sqlcmd version
• SCA-2688 - Improved the performance of the 'Apply' page when there are a large number of unapplied migrations

4.2.20030 - January 30th, 2020

Improvements:

• Updated SQL Compare Engine to 14.2.1.14869

Fixes:

• SCA-2680 - You can now use a network share when creating a project with SQL Source Control as development source
• SCA-2684 - We now return a consistent error if multiple operations try and access the development or shadow database while a write operation is already in progress

4.2.20023 - January 23rd, 2020

Improvements:

• Updated SQL Compare Engine to 14.1.10.14743
• SCA-2681 It is now impossible to automatically generate migrations when there are unapplied scripts in the project
• You can now access the Version Control integration when you use a SQL Source Control project as a development source

4.2.20022 - January 22nd, 2020

Features:

• Provision development databases using SQL Clone.
• Use a SQL Source Control project as a development source
• Share your changes with your team from within SSMS using the new Version Control integration for Git repositories.