Learn what's new across releases, with details of features, enhancements, and resolved issues.
SQL Source Control 8.1.24.24484Sep 1, 2026
Features
- Added fallback handling for invalid WAM authentication.
- Updated SQL Compare Engine to 17.0.0.31342.
SQL Prompt Pro 11.5.3.27255Sep 1, 2026
Features
- Added support for
Select in Object Explorer feature for Tables, Stored Procedures, Functions and Views in Microsoft Fabric databases.
- The
Check AI Availability button is now available at all times (previously required an open query editor window). An associated popup, where you can launch Prompt AI and Redgate Assistant, is added to improve usability.
- All Redgate Assistant tools now provide richer detail if something goes wrong -- similarly to what was done for the query execution plan in version 11.5.2.27061 -- which can save time and lead to better diagnosis.
Fixes
- Fixed an issue where SQL Prompt options could fail to save if the options file was temporarily locked.
- Fixed an issue where aggregate functions like
Max and Min showed the return type as Numeric instead of generic.
- Fixed an issue where the SQL Prompt was crashing when using Table Design in SSMS.
- Fixed an issue where SQL Prompt did not add square brackets to identifiers in the WINDOW clause.
- Fixed an issue where SQL query tab retained its text color after being disconnected from the server.
- Fixed an issue where
open new query in SSMS 20 would prompt for repeated authentication when connected to Azure database using MFA.
- Fixed an issue in SQL Prompt bulk actions where the text color was not applied correctly in dark mode.
SQL Test 4.4.11Aug 27, 2026
Fixes
- Fixed an issue that caused all databases to expand when refreshing a Database or Test class.
SQL Source Control v8.1.23.24464Aug 26, 2026
Features
- Added fallback handling for MSAL unknown_broker_error authentication failures.
- Added support for the NULL ON NULL / ABSENT ON NULL clause in the JSON_ARRAY function.
- Updated SQL Compare Engine to 17.0.0.31306.
Fixes
- Fixed an issue where the USER_SID system function would incorrectly be escaped as an identifier.
- 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.7.29428Aug 25, 2026
Features
- 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.
Fixes
- 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 Data Compare v16.1.7.29428Aug 25, 2026
Features
- 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.
SQL Prompt Pro 11.5.2.27061Aug 21, 2026
Fixes
- Unsupported query execution plan T-SQL statements (e.g.
CREATE TABLE) or scripts with multiple GO batches will now issue an explicit error when being processed in Redgate Assistant.
- Fixed an issue where background coloring was not applied correctly for SQL History 'DeleteConfirmation' and 'Rename Query' window.
- Redgate Assistant UI will now provide several suggestions if Redgate licensing authentication failed or if the backend could not connect within the allowed time window (e.g. confirm all prerequisites are met).
- Fixed a bug where talking to Prompt AI might cause SSMS to freeze.
SQL Source Control v8.1.22.24422Aug 18, 2026
Features
- Registering scripts folders containing ALTER TABLE ... ADD INDEX should now model the relevant index.
- Registering scripts folders containing ALTER TABLE ... ADD COLUMN or ALTER COLUMN should now update the specified column as appropriate.
- 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.
- Enhanced the Object Difference Pane with dark theme text support.
- Updated SQL Compare Engine to 17.0.0.31245.
Fixes
- Fixed an issue where commit comments were not displayed in the Comments column of Links Panel for changesets linked to Azure DevOps work items.
- 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.
- CREATE FULLTEXT STOPLIST and ALTER FULLTEXT STOPLIST statements without a trailing semicolon no longer cause the containing script file to fail to parse.
- 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.
- 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 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.
SQL Compare v16.1.6.29333Aug 18, 2026
Fixes
- 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 Data Compare v16.1.6.29333Aug 18, 2026
Fixes
- 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 Prompt Pro 11.5.1.26824Aug 14, 2026
Fixes
- Fixed an issue where the
Open In Excel option from the result grid was throwing an error.
SQL Compare v16.1.5.29295Aug 12, 2026
Features
- 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.
Fixes
- 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 Data Compare v16.1.5.29295Aug 12, 2026
Fixes
- Fixed “FieldMapping not valid for MatchingMappings” error when comparing databases containing AS EDGE or AS NODE graph tables with no primary key.
SQL Prompt Pro 11.5.0.26718Major versionAug 11, 2026
Features
- Added a button to open the Redgate Assistant window in SSMS toolbar.
- Added an option to open the Redgate Assistant window in SSMS query editor window context menu.
- Changed the model for AI autocompletion from Alibaba Cloud's Qwen3-Coder to Mistral AI's Devstral 2.
- The Redgate Assistant chat window will now automatically detect state changes without requiring to be closed and reopened.
- Turning on Prompt AI now also turns on Redgate Assistant if it is not already enabled.
Fixes
- Fixed an issue where SELECT statements in views containing Common Table Expressions (CTEs) were formatted incorrectly.
- Fixed an issue where users authenticated with Microsoft Entra MFA were repeatedly prompted for re-authentication on Visual Studio 2026.
- Fixed an issue where Redgate Assistant chat shows up as a blank window if the user is logged out when opening SSMS.
- Fixed an issue that could incorrectly throw an ObjectDisposedException when Redgate Assistant's MCP server was stopped.
- Fixed an issue that caused an execution timeout when viewing the script of a database object in Azure Synapse.
- Fixed an issue where function call formatting was not getting applied to JSON_OBJECT and JSON_OBJECTAGG.
- Fixed an issue where JSON_OBJECT did not suggest the ABSENT ON NULL or NULL ON NULL clauses.
- Fixed an issue where renaming an alias in a CTE could result in mismatched references and invalid SQL.
SQL Multi Script v1.7.9Aug 6, 2026
Features
- Added support for middle mouse button auto-scroll in the SQL Multi Script editor.
SQL Data Compare v16.1.4.29264Aug 6, 2026
Features
- Compatibility with SQL Compare 16.1.4.29264.
SQL Source Control v8.1.21.24376Aug 4, 2026
Features
- Updated SQL Compare Engine to 17.0.0.31116.
Fixes
- Fixed an issue where creating a non-clustered index on a graph table causes an undeployable difference.
- Fixed 'Data type not recognised' error for JSON columns during table rebuilds.
SQL Compare v16.1.3.29242Jul 31, 2026
Fixes
- 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 Data Compare v16.1.3.29242Jul 31, 2026
Fixes
- WHERE clause validation no longer warns about valid T-SQL such as NOT LIKE, EXISTS and subqueries.
SQL Source Control v8.1.20.24335Jul 30, 2026
Features
- Updated SQL Compare Engine to 17.0.0.30957.
Fixes
- 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.
- Fixed an issue where the changeset comment did not appear in the discussion panel of the linked work item in Azure DevOps Boards.
- Fixed an issue where installing or upgrading SQL Source Control failed on machines that did not have SSMS 21 or SSMS 22 installed.
SQL Compare v16.1.2.29188Jul 23, 2026
Features
- 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 Prompt Pro 11.4.2.26116Jul 23, 2026
Features
- Added a new MCP tool for Redgate Assistant, allowing it to fetch the query run plan for optimization.
Fixes
- Fixed an issue where query indentation formatting broke when comments were present inside parentheses.
- Fixed an issue where table definition was not fetched for Azure Synapse Dedicated Pools.
- Fixed an issue where
JSON_OBJECTAGG and JJSON_ARRYAGGJ were incorrectly suggested when utilizing "All non-aggregated columns".
- Fixed an issue where SQL query tab text had low contrast when Tab Coloring was enabled.
- Fixed an issue in SSMS 22.6 and later where SQL Error highlighting was disabled when IntelliSense was turned off by SQL Prompt.
- Removed unnecessary logging noise from Redgate Assistant chat UI operations.
SQL Data Compare v16.1.2.29188Jul 23, 2026
Features
- Compatibility with SQL Compare 16.1.2.29188.
SQL Source Control 8.1.19.24242Jul 22, 2026
Features
- Added MSAL authentication for Azure DevOps cloud connections (TFS2015), with MFA and multi-account support.
- Removed the unused IVersionedDatabaseProvider interface from the Migrations namespace.
- Updated SQL Compare Engine to 17.0.0.30836.
Fixes
- Fixed an issue where checkboxes could disappear in the Source Control Commit window, restoring their visibility and improving usability.
SQL Compare 16.1.1.29148Jul 14, 2026
Fixes
- 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 Data Compare v16.1.1.29148Jul 14, 2026
Features
- Compatibility with SQL Compare 16.1.1.29148.
SQL Prompt Pro 11.4.1.25856Jul 10, 2026
Features
- Added support for grouping Stored Procedures, Functions and Views by Schema in Object Explorer.
- Added a new MCP tool to retrieve build and IntelliSense errors of the content in the current editor window to complement the existing one to gather execution errors.
- Removed the
Open Data Modeler Object Explorer context-menu option for the selected database (SSMS only).
- Removed 9,500 character limit on Redgate Assistant MCP tool calls.
Fixes
- Fixed an issue where SQL Prompt CLI did not respect formatting exclusions.
- Fixed an issue where SQL Prompt would crash when a menu command fails to load.
- Fixed issue where Redgate Assistant MCP server could fail to launch if Redgate licensing was not yet ready.
- Fixed an issue where the Redgate Assistant MCP tool for checking T-SQL execution errors could crash when the script contained a batch with a severe syntax error.
SQL Source Control 8.1.18.24160Jul 8, 2026
Features
- Updated SQL Compare Engine to 17.0.0.30776.
SQL Test 4.4.9Jul 7, 2026
Fixes
- Fixed an issue that caused SQL Test to report incorrect code coverage for large test runs. Code coverage is now calculated and displayed correctly.
SQL Compare 16.1.0.29116Major versionJul 6, 2026
Features
- 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 Data Compare 16.1.0.29116Major versionJul 6, 2026
Features
- SQL Data Compare command line now stops if your project's WHERE clauses might have unintended side effects. Please pass /AllowDangerousWhereClauses as an option to compare anyway.
SQL Prompt Pro 11.4.0.25545Major versionJul 1, 2026
Features
- Released a new AI preview feature, Redgate Assistant, a chat based AI interface within SQL Prompt that can be used to generate SQL, fix bugs, and more.
- Redgate Assistant can be enabled in the SQL Prompt options, on the AI page, under the preview section.
- It can be accessed through the SQL Prompt menu button, or through the keybind Alt-A.
- Redgate Assistant is able to read the information inside your query editor window, database information (but not contents), and schema information.
- Due to a change in the licensing system, users will be logged out and need to log back in to SQL Prompt to continue using the product after this update.
SQL Compare 16.0.19.29095Jul 1, 2026
Features
- Added 'Information' as a valid/logLevel option in the command line tool.
SQL Data Compare 16.0.19.29095Jul 1, 2026
Features
- SQL Data Compare UI now shows a warning if your project’s WHERE clauses might have unintended side effects.
- Added 'Information' as a valid/logLevel option in the command line tool.
SQL Prompt Pro 11.3.18.25519Jun 30, 2026
Features
- Several improvements to reduce synchronization issues between client and server side access (Prompt AI and Query Index Analysis).
- Added support for grouping Tables by Schema in Object Explorer.
- Added support for new OPENROWSET BULK options in SQL Server 2005, SQL Server 2017, Azure SQL and Microsoft Fabric.
Fixes
- Prompt AI now asks the end user to log in when necessary instead of giving confusing generic error messages.
- Fixed an issue where Prompt AI would fail to load in SSMS 21
- Fixed an issue where JSON_OBJECTAGG did not format key-value pairs correctly.
- Fixed an issue where SQL Prompt was unable to disable the built-in SSMS IntelliSense in SSMS 22.6 and later versions.
SQL Multi Script 1.7.7Jun 25, 2026
Features
- Improved SQL Multi Script startup behavior to align with other products, avoiding automatic loading of the last opened project.
Fixes
- Improved performance when exporting large result sets to Excel using the "Save All..." option.
SQL Data Compare 16.0.18.29038Jun 18, 2026
Features
- Added 'Information' as a selectable minimum log level in Help > Minimum log levels.
SQL Multi Script 1.7.6Jun 4, 2026
Features
- Improved SQL Multi Script startup behavior to align with other products, avoiding automatic loading of the last opened project.
Fixes
- Improved performance when exporting large result sets to Excel using the "Save All..." option.
SQL Prompt Pro 11.3.16.24782Jun 3, 2026
Fixes
- Fixed an issue in SSMS 22.6 that could cause an unexpected error dialog to appear when accessing the SQL Prompt Manage License screen.
SQL Prompt Pro 11.3.15.24535May 28, 2026
Features
- Added Open Data Modeler Object Explorer context-menu option for the selected database to show Redgate Data Modeler in the default system browser (SSMS only).
Fixes
- Fixed an issue where SQL Prompt did not show suggestions for ORDER and columns while creating ORDERED CLUSTERED COLUMNSTORES INDEX.
- Fixed UI issues that caused some pages to become unreadable when the dark theme was enabled.
SQL Source Control 8.1.15.23845May 26, 2026
Features
- Updated SQL Compare Engine to 17.0.0.30484.
- Added support for KDiff3 - 0.9.98.
SQL Data Generator 4.8.8.7546May 21, 2026
Fixes
- Fixed broken links inside help pop-ups.
SQL Prompt Pro 11.3.14.24187May 18, 2026
Fixes
- Fixed problem that could permanently prevent usage of Prompt AI by having an always disabled Check Prompt AI availability command in the SQL Prompt main menu.
- Fixed an issue that caused suggestions to fail in SQL Prompt when string concatenation was used with TRIM.
- Fixed an issue in SSMS 22.6 where opening the Manage License screen in SQL Prompt could display an unexpected error dialog.
SQL Multi Script 1.7.5Major versionMay 14, 2026
Fixes
- Disabled editing of the server field in Connection Properties for existing Database Distribution List.
SQL Prompt Pro 11.3.13.23933May 12, 2026
Features
- Updated the SQL Prompt SSMS Check for Updates (CFU) flow to launch the SQL Toolbelt Essentials installer instead of the standalone SQL Prompt installer.
Fixes
- Fixed an issue where SQL Prompt did not auto-fill the default NUMERIC values for a stored procedure.
- Fixed an issue where SQL Prompt suggestions failed to load on read-only replicas in Availability Groups.
- Fixed issue where SQL History could cause errors and SSMS freezes when disabled or enabled via the SQL Prompt options.
- Fixed an issue where the COPY AS IN clause in the result grid returned duplicate values when multiple cell with identical values were selected using Ctrl+Click.
- Fixed an issue where the SQL Prompt right‑click context menu failed to appear in the Registered Servers window in SSMS 21 and SSMS 22 after signing out of SQL Prompt.
- Fixed issue that could cause the Prompt AI availability check to always fail in the same IDE session, even if AI access was subsequently restored (e.g. temporary network blip or server-side downtime). This removes the need to restart SSMS/VS to be able to re-use Prompt AI in those scenarios.
- Fixed an issue where SQL Prompt Table definition tooltip suggestions failed to load System-Versioning scripts for Temporal tables.
SQL Toolbelt Essentials UpdateMay 1, 2026
SQL Toolbelt Essentials UpdateApr 1, 2026
SQL Toolbelt Essentials UpdateMar 2, 2026
SQL Toolbelt Essentials UpdateFeb 2, 2026
SQL Toolbelt Essentials UpdateJan 5, 2026