SQL Compare 릴리스

Redgate Software데이터베이스 비교 도구
버전 16.1.x (2026년 9월 16일)(3)

릴리스 전반에서 새로 나온 내용을 살펴보세요. 기능, 개선 사항, 해결된 문제에 대한 자세한 정보를 제공합니다.

1월
2월
3월
4월
5월
6월
7월
8월
9월
10월
11월
12월
SQL Compare v16.1.9.295362026년 9월 16일
기능
  • Internal library updates.
SQL Compare v16.1.8.295112026년 9월 10일
기능
  • The new parser will now attempt to recover to the next statement inside of module (view, function, etc) bodies.
수정 사항
  • A snapshot of the target is no longer written after a deployment unless you asked for one on the 'Back up target before deployment' step.
  • Fixed the deployment wizard defaulting target snapshots to Schema Compare for Oracle's .onp file extension instead of .snp.
  • Fixed 'Failed to acquire access token for ActiveDirectoryInteractive: Unable to load DLL 'msalruntime' error when connecting using multi-factor authentication.
SQL Compare v16.1.7.294282026년 8월 25일
기능
  • Added support for the NULL ON NULL / ABSENT ON NULL clause in the JSON_ARRAY function.
  • Made UI updates in the progress dialog more resilient when large amounts of progress is being reported.
  • Started 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.
수정 사항
  • 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.
SQL Compare v16.1.6.293332026년 8월 18일
수정 사항
  • 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.
  • 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.
  • Fixed the deployment script header omitting the source control revision number when comparing SQL Source Control 'Data Source' revisions.
SQL Compare v16.1.5.292952026년 8월 12일
기능
  • 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.
수정 사항
  • 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.
  • 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.
SQL Compare v16.1.3.292422026년 7월 31일
수정 사항
  • Fixed ‘Data type not recognised’ error for JSON columns during table rebuilds.
  • Fixed an issue where creating a non-clustered index on a graph table causes an undeployable difference.
SQL Compare v16.1.2.291882026년 7월 23일
기능
  • 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 v16.1.1.291482026년 7월 14일
수정 사항
  • 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 v16.1.0.29116주요 버전2026년 7월 6일
기능
  • 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 v16.0.19.290952026년 7월 1일
기능
  • Added 'Information' as a valid/logLevel option in the command line tool.
SQL Compare v16.0.18.29038주요 버전2026년 6월 18일
기능
  • 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.
수정 사항
  • 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 v16.0.17.290042026년 6월 3일
수정 사항
  • 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 v16.0.16.289492026년 5월 21일
수정 사항
  • 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 v16.0.15.289002026년 5월 12일
기능
  • Added support for JSON_QUERY WITH ARRAY WRAPPER introduced in SQL Server 2025.
SQL Compare v16.0.14.288442026년 5월 5일
기능
  • 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.
수정 사항
  • The Edit Filter Rules dialog now adds nested AND/OR clauses correctly.
SQL Compare v16.0.13.287572026년 4월 21일
기능
  • 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.
수정 사항
  • Ignore Collations option now works for memory-optimised tables on SQL Server 2016+.
SQL Compare v16.0.11.286942026년 4월 8일
수정 사항
  • 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.286722026년 3월 31일
기능
  • Added support for ORDER clause on clustered and non-clustered columnstore indexes.
SQL Compare v16.0.9.286542026년 3월 24일
수정 사항
  • Fixed Null Reference exception when deploying a data type change to XML column.
SQL Compare v16.0.8.286342026년 3월 17일
수정 사항
  • Memory optimized tables with replaced indexes are now correctly modeled.
SQL Compare v16.0.6.285822026년 2월 24일
수정 사항
  • 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.284772026년 1월 20일
수정 사항
  • Many more system function names are now correctly recognized.
  • Fixed offline licensing workflow for SQL Compare docker container.
SQL Compare v16.0.3.284512026년 1월 14일
기능
  • 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.
수정 사항
  • Fixed a connection issue in SQL Snapper where "Encrypt" option was incorrectly set to True when the checkbox was unchecked.