Fixes

• Internal library updates.

Fixes

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

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.

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.

Fixes

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

Fixes

• Fixed Azure AD authentication when using the command line.

Fixes

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

Fixes

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

Fixes

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

Fixes

• Compatibility with SQL Data Compare 14.2.11.15654.

Fixes

• Internal library updates.

Fixes

• Internal library updates.

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.

Fixes

• Internal library updates.

Fixes

• Internal library updates.

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.

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.

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.

Fixes

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

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.

Features

• SQL Compare now supports Microsoft Azure Active Directory Interactive Authentication.

Fixes

• When mapping schemas, object text will now preserve three and four part naming.