SQL Compare 16.1 release notes
Published 23 July 2026
What's new in SQL Compare 16.0
Strengthening security when saving passwords
When you choose to remember credentials while saving a project file, SQL Compare will now save your password to the Windows Credential Store, whereas older versions also saved a copy to the project file. This makes sure that database passwords aren't accidentally shared with other users, and only users that know the password can connect to the database.
Support for connecting to the new SQL Server 2025 database
We have been busy upgrading our tests and fixing issues to make sure we're ready for when you start using SQL Server 2025. You can connect to SQL Server 2025 databases and use them as a Source or Target for comparisons and deployments.
There are some new features that we already support, like the JSON data type.
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
Internal
- Parser analysis and snapshot save now observe cancellation via a threaded CancellationToken instead of the ambient Database.Cancel signal; removed the temporary external-token linking in Database.
- Removed the unused IVersionedDatabaseProvider interface from the Migrations namespace
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
