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.
SQL Source Control v8.1.22.2442218 août 2026
Fonctionnalités
- 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.
Corrections
- 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.2933318 août 2026
Corrections
- 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.2933318 août 2026
Corrections
- 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.2682414 août 2026
Corrections
- Fixed an issue where the
Open In Excel option from the result grid was throwing an error.
SQL Compare v16.1.5.2929512 août 2026
Fonctionnalités
- 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.
Corrections
- 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.2929512 août 2026
Corrections
- 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.26718Version majeure11 août 2026
Fonctionnalités
- 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.
Corrections
- 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.96 août 2026
Fonctionnalités
- Added support for middle mouse button auto-scroll in the SQL Multi Script editor.
SQL Data Compare v16.1.4.292646 août 2026
Fonctionnalités
- Compatibility with SQL Compare 16.1.4.29264.
SQL Source Control v8.1.21.243764 août 2026
Fonctionnalités
- Updated SQL Compare Engine to 17.0.0.31116.
Corrections
- 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.2924231 juil. 2026
Corrections
- 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.2924231 juil. 2026
Corrections
- WHERE clause validation no longer warns about valid T-SQL such as NOT LIKE, EXISTS and subqueries.
SQL Source Control v8.1.20.2433530 juil. 2026
Fonctionnalités
- Updated SQL Compare Engine to 17.0.0.30957.
Corrections
- 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.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 Prompt Pro 11.4.2.2611623 juil. 2026
Fonctionnalités
- Added a new MCP tool for Redgate Assistant, allowing it to fetch the query run plan for optimization.
Corrections
- 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.2918823 juil. 2026
Fonctionnalités
- Compatibility with SQL Compare 16.1.2.29188.
SQL Source Control 8.1.19.2424222 juil. 2026
Fonctionnalités
- 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.
Corrections
- Fixed an issue where checkboxes could disappear in the Source Control Commit window, restoring their visibility and improving usability.
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 Data Compare v16.1.1.2914814 juil. 2026
Fonctionnalités
- Compatibility with SQL Compare 16.1.1.29148.
SQL Prompt Pro 11.4.1.2585610 juil. 2026
Fonctionnalités
- 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.
Corrections
- 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.241608 juil. 2026
Fonctionnalités
- Updated SQL Compare Engine to 17.0.0.30776.
SQL Test 4.4.97 juil. 2026
Corrections
- 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.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 Data Compare 16.1.0.29116Version majeure6 juil. 2026
Fonctionnalités
- 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.25545Version majeure1 juil. 2026
Fonctionnalités
- 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.290951 juil. 2026
Fonctionnalités
- Added 'Information' as a valid/logLevel option in the command line tool.
SQL Data Compare 16.0.19.290951 juil. 2026
Fonctionnalités
- 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.2551930 juin 2026
Fonctionnalités
- 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.
Corrections
- 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.725 juin 2026
Fonctionnalités
- Improved SQL Multi Script startup behavior to align with other products, avoiding automatic loading of the last opened project.
Corrections
- Improved performance when exporting large result sets to Excel using the "Save All..." option.
SQL Data Compare 16.0.18.2903818 juin 2026
Fonctionnalités
- Added 'Information' as a selectable minimum log level in Help > Minimum log levels.
SQL Multi Script 1.7.64 juin 2026
Fonctionnalités
- Improved SQL Multi Script startup behavior to align with other products, avoiding automatic loading of the last opened project.
Corrections
- Improved performance when exporting large result sets to Excel using the "Save All..." option.
SQL Prompt Pro 11.3.16.247823 juin 2026
Corrections
- 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.2453528 mai 2026
Fonctionnalités
- 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).
Corrections
- 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.2384526 mai 2026
Fonctionnalités
- Updated SQL Compare Engine to 17.0.0.30484.
- Added support for KDiff3 - 0.9.98.
SQL Data Generator 4.8.8.754621 mai 2026
Corrections
- Fixed broken links inside help pop-ups.
SQL Prompt Pro 11.3.14.2418718 mai 2026
Corrections
- 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.5Version majeure14 mai 2026
Corrections
- Disabled editing of the server field in Connection Properties for existing Database Distribution List.
SQL Prompt Pro 11.3.13.2393312 mai 2026
Fonctionnalités
- Updated the SQL Prompt SSMS Check for Updates (CFU) flow to launch the SQL Toolbelt Essentials installer instead of the standalone SQL Prompt installer.
Corrections
- 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 Update1 mai 2026
SQL Toolbelt Essentials Update1 avr. 2026
SQL Toolbelt Essentials Update2 mars 2026
SQL Toolbelt Essentials Update2 févr. 2026
SQL Toolbelt Essentials Update5 janv. 2026