16.1.7.29428 - 25 August 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-361665: Fixed an issue where PolyBase external data sources using a SQL Server 2019+ generic connector generated an invalid deployment script and showed a permanent false difference against scripts folders and snapshots
• ZD-361618: Support for the NULL ON NULL / ABSENT ON NULL clause in the JSON_ARRAY function

Improvement

• Made UI updates in the progress dialog more resilient when large amounts of progress is being reported
• We’re starting to roll out a new implementation of the SQL Compare TSQL parser. This new implementation has improved performance and should allow for more precise handling of unsupported syntax. We’ll start by rolling out to Frequent Updates users, then a small percentage of users on the default updates channel. As always, please contact support if you run into any issues.

16.1.6.29333 - 18 August 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-362166: Fixed an issue where the USER_SID system function would incorrectly be escaped as an identifier
• Fixed an issue where rebuilding a table to make it system-versioned temporal generated an unrunnable script when the target already had one of the two period columns as an ordinary column
• ZD-361357: The number of progress events reported when performing column mappings has been capped. This prevents the UI being overwhelmed with events and hanging the application.
• ZD-362488: Fixed the deployment script header omitting the source control revision number when comparing SQL Source Control “Data Source” revisions

16.1.5.29295 - 12 August 2026

FREQUENT UPDATES RELEASE

Bug fix

• A column definition carrying a HIDDEN clause without GENERATED ALWAYS AS ROW START/END no longer causes the containing script file to fail to parse
• CREATE FULLTEXT STOPLIST and ALTER FULLTEXT STOPLIST statements without a trailing semicolon no longer cause the containing script file to fail to parse
• ZD-361518: Fixed an issue where rebuilding a table to make it system-versioned temporal generated an unrunnable script when the target already had PeriodStart/PeriodEnd columns with SYSTEM_VERSIONING off

Improvement

• Improved error handling for CREATE COLUMN MASTER KEY, CREATE COLUMN ENCRYPTION KEY, CREATE AVAILABILITY GROUP and CREATE/ALTER EXTERNAL RESOURCE POOL statements found in script folders - they should now raise a parser error instead of being silently ignored
• Registering scripts folders containing ALTER TABLE … ADD COLUMN or ALTER COLUMN should now update the specified column as appropriate
• Registering scripts folders containing ALTER TABLE … ADD INDEX should now model the relevant index

16.1.4.29264 - 06 August 2026

FREQUENT UPDATES RELEASE

Features

• Internal library updates

16.1.3.29242 - 31 July 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-360555: Fix ‘Data type not recognised’ error for JSON columns during table rebuilds
• ZD-360534: Fixed an issue where creating a non-clustered index on a graph table causes an undeployable difference

16.1.2.29188 - 23 July 2026

FREQUENT UPDATES RELEASE

Bug fix

• ZD-359333: Fixed a few places that could cause a NullReferenceException: permissions on securables that aren’t yet supported, on non-object securables whose name collides with a function, and on table-valued functions registered from a scripts folder.

16.1.1.29148 - 14 July 2026

FREQUENT UPDATES RELEASE

Bug fix

• Fixed a NullReferenceException that could occur when comparing mappings for non-database sources such as backups, snapshots, or scripts folders
• Fixed a NullReferenceException that could occur when navigating to the next/previous difference in the results grid

16.1.0.29116 - 06 July 2026

New feature

• SQL Compare command line now stops if your project’s WHERE clauses might have unintended side effects when deploying static data. Use /AllowDangerousWhereClauses to suppress the error.