SQL Compare 16.1 release notes
Published 23 July 2026
What's new in SQL Compare 16.1
Warnings for risky WHERE clauses
If you use a WHERE clause to filter the rows included in a comparison, SQL Data Compare now checks it before you run the comparison and warns you if it looks unsafe. For example, it flags functions we don't recognize or a stray ; that could interfere with the generated script. Filters using standard T-SQL syntax will validate without any extra prompts.
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.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
