SQL Compare 14

SQL Compare 14.2 release notes

What's new in SQL Compare 14.2

SQL Compare now supports Azure Active Directory Interactive Authentication, including multi-factor authentication

14.3.2.16501 - July 30th 2020

FREQUENT UPDATES RELEASE

Fixes

  • The current highlighted row in the differences grid is deselected (de-highlighted, not unticked.) after a refresh.
  • SC-10890: Azure AD users are now registered on an Azure SQL database
  • SC-10891: When generating a script for a partition scheme change, an exception is no longer thrown

14.3.1.16487 - July 27th 2020

FREQUENT UPDATES RELEASE

Fixes

  • Spurious 'Table rebuild fields dropped' warnings are no longer displayed during a table rebuild

14.3.0.16423 - July 20th 2020

FREQUENT UPDATES RELEASE

Features

  • SQL Compare will now reject self-signed certificates when connecting over the internet to SQL Servers with force encryption enabled
  • SQL Compare command line on Linux now supports Azure Active Directory Password authentication

14.2.19.16383 - July 13th 2020

FREQUENT UPDATES RELEASE

Internal library updates.

14.2.18.16317 - July 6th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10865: Fixed the filter pane behaviour when changing All Object Types.

14.2.18.16251 - June 29th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10852: Fixed SQL Server version not being read from SSDT/SCA project file
  • SC-10853: When rebuilding an index, the order of included columns is now respected
  • ZD160360: Fixed an occasional hang when comparing CLR assemblies.

14.2.17.16188 - June 23rd 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10851: Fixed object existence check when changing between a SQL function and a CLR function
  • Fixed an issue with registering scripts folders on Linux.

14.2.16.16006 - June 4th 2020

Fixes

  • SC-10848: Fixed issue where saved passwords could be forgotten

14.2.15.15984 - June 1st 2020

FREQUENT UPDATES RELEASE

Fixes

  • Fixed Azure AD authentication when using the command line

14.2.14.15839 - May 18th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-7052: Only warn about potential data loss when precision/scale has changed in a way that could lose data.

14.2.13.15781 - May 11th 2020

FREQUENT UPDATES RELEASE

Fixes

  • Improved startup performance in cases where networking issues were delaying product start.

14.2.12.15739 - May 4th 2020

FREQUENT UPDATES RELEASE

Fixes

  • ZD160292: In the diff view, permissions are now sorted by user and then by action.

14.2.11.15654 - April 29th 2020

FREQUENT UPDATES RELEASE

Compatibility with SQL Data Compare 14.2.11.15654

14.2.10.15571 - April 22nd 2020

FREQUENT UPDATES RELEASE

Internal library updates

14.2.9.15508 - April 9th 2020

Internal library updates

14.2.8.15465 - April 6th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10806 Fixed an issue that could occur while dropping tables with foreign keys with a scripts folder target

  • SC-10801: Fixed the case when a computed column is added to a temporal table.

14.2.7.15427 - March 30th 2020

FREQUENT UPDATES RELEASE

Internal library updates

14.2.6.15412 - March 23rd 2020

FREQUENT UPDATES RELEASE

Internal library updates

14.2.5.15352 - March 16th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10797: Fixed a script ordering error when altering a queue with an event notification on it
  • SC-10798: Fixed support for newer SQL Server features (introduced in SQL Server 2016 or later) on Azure Managed Instances

14.2.4.15334 - March 5th 2020

Fixes

  • Fix performance issue with large text objects when the "Ignore WITH element order" option is enabled.
  • SC-10795: Fixed a crash when opening the Create Scripts Folder dialog

14.2.3.15242 - March 2nd 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10786: When dropping a user with a permission set on a built-in user from a scripts folder, the permission will now be removed from the built-in user

14.2.2.15139 - February 24th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10785: When dropping a column, clustered columnstore indexes on the table are no longer dropped

14.2.1.15041 - February 11th 2020

FREQUENT UPDATES RELEASE

Fixes

  • SC-10773: Scripts folders containing Microsoft Database projects are now correctly recognized
  • SC-10774: When using the "Don't use transactions in deployment scripts" option, SQL Compare no longer includes a rollback statement at the end of the script
  • SC-10777: Deploying a trigger change to a scripts folder no longer causes duplicate EXEC sp_settriggerorder statements
  • SC-10776: When sys.sql_expression_dependencies claims a dependency against an object that does not exist in the database, SQL Compare now ignores the dependency and outputs an error to the logfile
  • SC-10763: Scripts folders without a valid metadata file will now default to SQL Server 2019 instead of SQL Azure DB

14.2.0.14846 - January 29th 2020

FREQUENT UPDATES RELEASE

Features

  • SQL Compare now supports Azure Active Directory Interactive Authentication

Fixes

  • SC-10766: When mapping schemas, object text will now preserve three and four part naming

Didn't find what you were looking for?