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

• Internal library updates.

Fixes

• Internal library updates.

Fixes

• SC-10308: Renaming a column included in a temporal table primary key will no longer produce an invalid deployment script.

Fixes

• ZD-242682: Deploying a memory optimized table type will now longer ignore indexes when the option is set.

Fixes

• SC-10950: Extended properties representing sensitivity classifications are now treated as sensitivity classifications on versions of SQL Server that support the ADD SENSITIVITY CLASSIFICATION syntax.
• Fixed a crash when opening the Server dropdown in SQL Snapper.

Fixes

• External tables are no longer erroneously registered as regular tables.
• SC-10945: Role members are now sorted in the SQL view.

Fixes

• Compatibility with SQL Data Compare 14.4.14.17548.

Fixes

• Security policies now respect the "Add object existence checks" option.

Fixes

• Compatibility with SQL Data Compare 14.4.12.17429.

Fixes

• Internal library updates.

Fixes

• Compatibility with SQL Data Compare 14.4.10.17174.

Fixes

• Fixed regression where static data could not be deployed to a table referenced by a system named foreign key.
• Comparing spatial indexes no longer gives false differences.

Fixes

• Internal library updates.

Fixes

• SQL Compare now generates correct update script when changing data type of PK column of temporal table.

Fixes

• SC-10919: Improved handling of SQL SET statements in scripts folders.
• SC-4733: When the Ignore Permissions option is enabled, and a table is rebuilt, SQL Compare now restores its original permissions rather than deploying its original permissions.

Fixes

• Internal library updates.

Fixes

• Static data differences are now correctly shown in the command line list of differences when using /include:staticdata.

Fixes

• SC-10907: Amended script order when adding an IDENTITY field to a temporal table.
• SCA-2749: When comparing a scripts folder using /include:staticdata, SQL Compare Command Line will no longer compare data for tables without static data defined.

Fixes

• SC-10906: SQL Compare no longer tries to recreate an existing clustered columnstore index when a column's datatype is modified.

Fixes

• ZD-166228: Fixed "SQL Change Automation scripting error".

• Improved consistency between command line and UI behaviors.