Fixes

• "Encrypt" and "Trust server certificate" server connection checkbox values are now loaded with server connection details from server dropdown.

Fixes

• Warn that non-primary filestream filegroups of tables will need to be created manually.

Fixes

• Fixed issue with table mappings not appearing when connecting through Azure MFA to a managed instance.

Fixes...

Fixes

• Adding 'NOT NULL' to a temporal table column will now update values in the history table to the default value and display a warning.
• Primary keys are now correctly dropped before being replaced when using system versioning.

Features

• Added support for long file paths in Microsoft Windows when enabled in the Windows registry.

Fixes

• SCHEMABINDING is correctly dropped on functions that are created WITH EXECUTE AS...

Features

• Added support for the 'OPTIMIZE_FOR_SEQUENTIAL_KEY' index option.

Fixes

• Fixed an issue in parsing query MATCH syntax from scripts folders.

Features

• Upgraded to Microsoft.Data.SqlClient 5.0.0.

Fixes

• Fixed an issue where database connections failed due to mishandling of the Failover Partner parameter.

Fixes

• SQL Compare will now only rebuild a table...

Features

• Added support for T-SQL undocumented virtual column '%%physloc%%'.

Fixes

• Fixed deployment script object existence checks, when source and target have column names that differ only in case.

Features

• Updated compatibility with SQL Data Compare 14.8.4.21440.

Fixes

• Fixed an issue with verifying server certificates when an explicit port number is set.

Features

• Internal library updates.

Features

• Added the option to use 'CREATE OR ALTER' statements when deploying to servers that support this feature.

Fixes

• Fixed an issue with recognising the data type of fields that are user defined types, in history tables of temporal tables.

Features

• Updated compatibility with SQL Data Compare 14.7.6.21017.

Fixes

• Fixed an...

Fixes

• Delimit credential names for external data sources.

Fixes

• Fixed issue which caused data compression settings on partitioned temporal tables to not be read from scripts folders.

Fixes

• 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.
• SQL Compare can...

Fixes

• Fixed broken table renaming technique.

Fixes

• Internal library updated.

Features

• Improved performance when reading from backup files.

Fixes

• Fixed error 'field change calculation failed in TableRebuildChecker' when deploying in certain mapping scenarios.

Features

• Internal library updated.

Fixes

• ZD-245196: Deploying a full text catalog along with its owner will no longer duplicate the CREATE USER statement.
• SC-10963: The /makescripts option on the command line no longer writes out migration blocks metadata for non-migration blocks databases.

Fixes

• SC-10959: SQL Compare now properly handles temporal tables on partition schemes.

Fixes

• Internal library updates.

Fixes

• Fixed "Multi-module assemblies are not supported when loading from memory".

Fixes

• Internal library updates.

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...

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-...