SQL Compare Versions

Découvrez les nouveautés dans chaque version, avec des détails sur les fonctionnalités, les améliorations et les problèmes résolus.

janv.
févr.
mars
avr.
mai
juin
juil.
août
sept.
oct.
nov.
déc.
SQL Compare v16.1.2.2918823 juil. 2026
Fonctionnalités
  • 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.
SQL Compare 16.1.1.2914814 juil. 2026
Corrections
  • 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.
SQL Compare 16.1.0.29116Version majeure6 juil. 2026
Fonctionnalités
  • 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.
SQL Compare 16.0.19.290951 juil. 2026
Fonctionnalités
  • Added 'Information' as a valid/logLevel option in the command line tool.
SQL Compare 16.0.18.29038Version majeure18 juin 2026
Fonctionnalités
  • Added Information as a selectable minimum log level in Help > Minimum log levels.
  • Scripts registered from folders now report unsupported SQL statements (such as ALTER SEQUENCE, ALTER USER, ALTER SCHEMA) as parser messages that highlight the problematic SQL, instead of silently ignoring them.
Corrections
  • Fixed parsing of ALTER TABLE ALTER COLUMN where COLLATE, MASKED WITH and NULL/NOT NULL appear together (e.g. in stored procedure bodies).
SQL Compare 16.0.17.290043 juin 2026
Corrections
  • Fixed parsing of SQL Server 2019 graph query syntax (SHORTEST_PATH, FOR PATH, WITHIN GROUP (GRAPH PATH)) in stored procedure and view bodies.
  • Fixed an issue where scripting options were not being honored during script generation.
SQL Compare 16.0.16.2894921 mai 2026
Corrections
  • Fixed an issue when encountering columns with defaults that use SQL Server functions that don’t have trailing parenthesis e.g. current_date.
  • Fixed a PlatformNotSupportedException when generating Classic HTML or Excel reports from the CLI.
SQL Compare 16.0.15.2890012 mai 2026
Fonctionnalités
  • Added support for JSON_QUERY WITH ARRAY WRAPPER introduced in SQL Server 2025.
SQL Compare v16.0.14.288445 mai 2026
Fonctionnalités
  • The Docker image base has been updated from Ubuntu Noble to Alpine 3.23, reducing image size and resolving security vulnerabilities in the base OS. If you use this image as a base for your own Dockerfile, you will need to update it to use Alpine-compatible commands (e.g. apk add instead of apt-get install).
  • Added support for SET TEXTSIZE -1 in stored procedure bodies.
Corrections
  • The Edit Filter Rules dialog now adds nested AND/OR clauses correctly.
SQL Compare v16.0.13.2875721 avr. 2026
Fonctionnalités
  • Added support for the CURRENT_DATE keyword introduced in SQL Server 2025.
  • Added support for JSON_ARRAYAGG and JSON_OBJECTAGG aggregate functions introduced in SQL Server 2025.
Corrections
  • Ignore Collations option now works for memory-optimised tables on SQL Server 2016+.
SQL Compare v16.0.11.286948 avr. 2026
Corrections
  • Fixed a problem where 'PERIOD FROM SYSTEM TIME' is added between an existing column and a new one.
  • Fixed an issue where function dependencies on tables might not be recognized correctly if a user-defined table type existed with the same name as the table.
SQL Compare v16.0.10.2867231 mars 2026
Fonctionnalités
  • Added support for ORDER clause on clustered and non-clustered columnstore indexes.
SQL Compare v16.0.9.2865424 mars 2026
Corrections
  • Fixed Null Reference exception when deploying a data type change to XML column.
SQL Compare v16.0.8.2863417 mars 2026
Corrections
  • Memory optimized tables with replaced indexes are now correctly modeled.
SQL Compare v16.0.6.2858224 févr. 2026
Corrections
  • Fixed an issue where SQL Compare would fail to handle CREATE EXTERNAL MODEL syntax in stored procedure or function bodies.
SQL Compare v16.0.4.2847720 janv. 2026
Corrections
  • Many more system function names are now correctly recognized.
  • Fixed offline licensing workflow for SQL Compare docker container.
SQL Compare v16.0.3.2845114 janv. 2026
Fonctionnalités
  • Added support for || string concatenation operator introduced in SQL Server 2025.
  • Improved error message for certain invalid filter files.
  • Database collation is now written to snapshots.
Corrections
  • Fixed a connection issue in SQL Snapper where "Encrypt" option was incorrectly set to True when the checkbox was unchecked.