14.6.20.20708 - Mar 1st, 2022

FREQUENT UPDATES RELEASE 

Fixes

• Delimit credential names for external data sources

14.6.19.20650 - Feb 22nd, 2022

FREQUENT UPDATES RELEASE 

Fixes

• ZD-256556: Fixed issue which caused data compression settings on partitioned temporal tables to not be read from scripts folders

14.6.18.20606 - Feb 15th, 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-264118: Stop rebuilding temporal tables and their history tables due to system named constraint and index name differences when the option "Ignore system named constraint and index names" is used
• ZD-264035: SQL Compare can now deploy text objects containing line continuations when Add object existence checks is enabled

14.6.17.20533 - February 3rd 2022

FREQUENT UPDATES RELEASE

Features

• SQL Compare no longer uses migration scripts from the Custom Scripts folder when generating a deployment script

14.6.16.20465 - January 25th 2022

FREQUENT UPDATES RELEASE

Internal library updates

14.6.15.20403 - January 12th 2022

FREQUENT UPDATES RELEASE

Fixes

• ZD-261847: Add support for T-SQL functions CURRENT_TIMEZONE_ID and TRANSLATE
• ZD-263527: A foreign key that references the key column(s) of an index will be correctly handled if that index changes in such a way as the only changes are in its non-key columns
• ZD-260221: Query on sys.parameters now runs WITH (NOLOCK)

14.6.14.20342 - December 22nd 2021

FREQUENT UPDATES RELEASE

Features

• Improved warning message when creating users without an associated login

Fixes

• ZD-262581: Add support for T-SQL undocumented virtual column %%lockres%%
• ZD-260221: More queries now run WITH (NOLOCK)

14.6.13.20238 - December 8th 2021

FREQUENT UPDATES RELEASE

Fixes

• ZD-262649: Fixed parsing of file paths in bulk insert statements

14.6.12.20158 - November 29th 2021

FREQUENT UPDATES RELEASE

Features

• To support automation environments, the SQL Data Compare command line now has an /allUsers flag that can be used when activating to allow it to be used by all users, including service accounts

14.6.11.20142 - November 22nd 2021

FREQUENT UPDATES RELEASE

Internal library updates

14.6.10.20102 - November 10th 2021

Fixes

• ZD-260283: Fix object reference error in SQL Snapper when attempting to create a database snapshot

14.6.9.20059 - November 1st 2021

FREQUENT UPDATES RELEASE

Fixes

• ZD-261137: Support for SQL Server 2019 differential backups fixed

14.6.8.20031 - October 26th 2021

FREQUENT UPDATES RELEASE

Fixes

• ZD-256677: Fix issue of usages of AT TIME ZONE leading to comparison differences which do not change the function of scripts, but which do not go away after deployment.
• ZD-260222: Fix queries to use WITH (NOLOCK) consistently when reading database schema

14.6.7.20011 - October 18th 2021

FREQUENT UPDATES RELEASE

Fixes

• ZD256971: Fix text diff view when an extended property is added or removed in the middle
• ER-57: Fix null reference error when deploying from a snapshot file.
• ZD259357: Fixed issue in the project settings dialog where the username for a database using Active Directory universal with MFA auth could get copied over the other database's username

14.6.6.19949 - October 5th 2021

FREQUENT UPDATES RELEASE

Fixes

• ZD-259248: Fixed parsing error involving schema-qualified DATA values in the PREDICT operator
• ZD-259150: Fixed issue with modal windows not appearing on expected monitor
• ZD-259508: Fixed deployment order of user-defined types when deploying from a snapshot

14.6.5.19910 - September 27th 2021

FREQUENT UPDATES RELEASE

Fixes

• ZD-257212: Changes to role owners now get applied to scripts folders.
• ZD-254395: Fix to failing deployment script when dropping a function that is referred to by a constraint.
• SC-11006, ER-55: Fixed a crash when loading a snapshot containing several external tables with the same name

14.6.4.19846 - September 20th 2021FREQUENT UPDATES RELEASE

Fixes

• ZD256698: Support for clustered columnstore indexes in scripts folders where sp_autostats has been set to OFF

14.6.3.19802 - September 16th 2021

FREQUENT UPDATES RELEASE

Fixes

• Fixed Active Directory universal with MFA authentication

14.6.2.19746 - September 13th 2021

FREQUENT UPDATES RELEASE

Fixes

• Fixed parsing of unicode strings in search properties and aliases

14.6.1.19650 - September 6th 2021

FREQUENT UPDATES RELEASE

Internal library updates

14.6.0.19635 - August 19th 2021

FREQUENT UPDATES RELEASE

Internal library updates