Fixes

• SQL Compare will now only rebuild a table when the filegroup differs just by casing if the "Use case-sensitive object definition" comparison option is on.

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

Fixes

• Changing a column from a user defined type and simultaneously dropping that user defined type no longer attempts to rebind the type after dropping it.
• Create Partition Scheme statements in scripts folders which contain too many filegroups for their partition function will now be read in as SQL Server does, i.e. the excess filegroups will be ignored.
• Permissions on the 'dbo' special user are now registered correctly.
• The null unicode character no longer...

Fixes

• SC-10677: Now avoids stack overflow with heavily nested computed columns more stringently. Some computed columns may show a syntax-only difference between live and scripts databases if they couldn't be parsed; this can be fixed by deploying the live version to the scripts folder.
• SC-10666: The IsSQLCloneDatabase extended property no longer appears in comparisons, so that it can't be accidentally deployed to non-clone databases.
• SC-10682: Sorting the grid...