Toad for SQL Server 2026 R2 - Release Notes

Toad for SQL Server 2026 R2

Toad for SQL Server 2026 R2

Release Notes

Wednesday, June 3, 2026

Contents

About Toad for SQL Server

With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management, and develop SQL more efficiently.

Toad also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.

System Requirements

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Requirement Details

Platform

2 GHz processor (recommended minimum)

Memory

8 GB of RAM minimum, 16 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

800 MB to install Toad

104 MB to run Toad

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

Windows Server® 2022

Windows Server® 2025

Windows® 8.1 (64-bit)

Windows® 10

Windows® 11

Deprecated Version of Windows

Toad for SQL customer support will not be available for the following operating systems as Microsoft has stopped providing support for these platforms.

  • Microsoft Windows 8 (64-bit)
  • Microsoft Windows Server 2008 R2 (64-bit)
.NET Framework

Microsoft® .NET Framework 4.7.2

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 11 or later

Screen

Recommended maximum DPI settings for Toad are 125%. It is possible to use Toad up to 200% but some dialog windows will not be completely usable anymore.

Maximum tested resolution for Toad is 1920 x 1080 px.

Copy/Move Database Wizard

The SQL Server Backward Compatibility package is required to use the Copy/Move Database wizard.

Log Reader

The Log Reader requires version 8.0 DLL files in the Microsoft Visual C++ 2005 SP1 Redistributable Package. If these files do not exist on the client, you will need to install them to use some functionality in the Log Reader.

http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Requirement Details

Database Server

SQL Server 2016

SQL Server 2017

SQL Server 2019

SQL Server 2022

SQL Server 2025 (tolerant support)

Notes: 

  • SQL Server Compact Edition is not supported.
  • Storage Management is not available on SQL Server Express.

Note: To use Access 2016 64-bit to connect to an Access database in Toad, the Microsoft Access Database Engine is required and might not be included in the Access installation. The engine must match the architecture (bitness) of Toad.

Deprecated Version of Database Server

Toad for SQL customer support will not be available for the following Database Server as Microsoft has stopped providing support for these platforms.

  • SQL Server 6.0
  • SQL Server 6.5
  • SQL Server 7.0
  • SQL Server 2000
  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2008 R2
Cloud Database Service

SQL Azure, Azure SQL Data Warehouse, and Azure SQL Managed Instance database

Note:  To be able to utilize a majority of Toad functionality, please grant VIEW DEFINITION on the SQL Azure databases you want to work with.

Virtualization Support

Requirement Details
Application Virtualization

When deploying Toad in a virtualization environment, for best results ensure the system accurately reflects the applicable client hardware and software requirements listed in this document.

Toad has been developed using Microsoft guidelines (see Remote Desktop Services programming guidelines) and can be deployed and operated in virtualization environments such as Citrix XenApp, Microsoft App-V, and VirtualBox.

Install Toad on Citrix® Systems

User Requirements

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User—on the computer.

If a Power User installs Toad, a Restricted User cannot do the following:

  • Associate file extensions.
  • View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.

User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:

  • To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security features.

Resolved Issues and Enhancements

New Features or Enhancements

Toad for SQL Server 2026 R2

Enhancement ID Description
TSS-3112

Toad for SQL Server adds tolerant platform support for Microsoft SQL Server 2025 and Windows Server 2025. In this release, Toad can be installed and run on Windows Server 2025, connect to SQL Server 2025 using all supported authentication methods, and execute core workflows such as object browsing, query editing and execution, comparison, automation, and search without critical errors.

TSS-3111

Toad for SQL Server introduces Toad Chat – a conversational AI interface that provides in-product assistance for working with SQL queries and Toad features.

Toad Chat enables users to interact with AI-powered capabilities directly within the application, helping to explain, optimize, and validate SQL statements, as well as provide guidance based on official product documentation.

The feature integrates multiple AI capabilities through a unified chat interface, allowing users to streamline query analysis and improve productivity without leaving their workflow.

Toad Chat is available within the main application interface as a dockable panel and can also be accessed from key areas such as Query Builder, Query Editor, and Object Explorer. Users can send full queries or selected query segments for analysis, and apply AI-generated suggestions directly to their active query tabs.

Toad for SQL Server 2026 R1

Enhancement ID Description
TSS-3020

Introducing new subscription licensing with a single installer for all editions, covering both online and offline usage.

Installer

A single installer supports all editions. Toad for SQL Server can handle all license types without requiring separate installers for online subscription or offline licenses.

Licensing

Subscription licenses can be activated directly on your device for offline use.

Toad for SQL Server 2025 R1

Enhancement ID Description
TSS-2946

AIExplain is an advanced new feature that uses AI technology to help users better understand complex SQL queries and scripts. With AIExplain, users can quickly analyze and interpret intricate SQL statements, making it easier to understand their logic, intent, and overall purpose.

Where to find AIExplain:

  • SQL Editor toolbar

  • Script tab for supported object types

  • Right-click context menu for supported object types

Supported Objects:

Procedures, Functions, Views, Tables, Indexes, Databases, Sequences, Synonyms

Note: AIExplain is a preview feature available to Toad for SQL Server Subscription users. Please refer to the Knowledge Base for instructions on how to enable it. Learn more about AIExplain at Toad World

TSS-2639 Improvements to the Filter options in the Data Compare wizard now allow users to easily import and export comparison filters, streamlining the setup of repeated comparison tasks.
TSS-2606 The Text Diff Viewer now support saving comparison results for later use. Users can export comparison outputs to a file and reopen them at any time, enabling quick review or re-execution of comparison tasks without reconfiguring comparison settings.
TSS-2608 Toad for SQL Server now includes a table Data Search capability. This new feature enables users to perform comprehensive searches across data stored in tables and views. Users can locate and retrieve information that matches a specific search phrase, supporting both text and numeric data types across tables, views, and databases.

 

Resolved Issues

The following is a list of issues addressed in this release of Toad for SQL Server:

Resolved Issues in 2026 R2

Feature Resolved Issues Defect ID
UI Open File dialog takes ~2 minutes to appear TSS-3063
Installation Don’t Ask Again option does not work for Additional Software window TSS-3062
SQL Azure SQL Azure Portal link opens outdated/broken page TSS-3061
Installation Toad for SQL Server 2026 R1 EXE does not allow MSI extraction via /extract switch TSS-3091

Resolved Issues in 2026 R1

Feature Resolved Issues Defect ID
Automation Schedule automation script does not generate export file in TSS subscription TSS-2684
SQL Azure Can't connect to Azure SQL using Active Directory Universal with MFA in Toad for SQL Server 2025 R1 TSS-2981

Resolved Issues in 2025 R1

Feature Resolved Issues Defect ID
Schema Compare Unable to perform a Schema Compare between two SQL Servers TSS-2194
DevExpress Dark style theme ToadBlue2014 skin reverts back to DevExpress Dark Style on close and relaunch TSS-2610
DarkRoom theme Incorect letter color when using DarkRoom theme TSS-2604
Query Builder Query is changed and errors are raised when visualization is finished TSS-2308
Data Compare Data compare consider the last searched object set instead of all mapped objects TSS-2243
Schema Compare Stored Procedures not identified as different when schema compare is performed TSS-2617
Schema Compare CREATE keyword not found Exception occurred on generating script post Schema compare TSS-2612
Data Compare Data Compare identifies a single record of table EStaff as existing only on both source and target TSS-2599

 

 

 

 

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature

Known Issue

Defect ID

Integration

[SSMS Integration] Plugin works only on SSMS versions 19 and 20

TSS-3110
Migration

Settings and options don't migrate from previous version.

Note: Before installing the latest version of Toad for SQL Server, make sure to export your connections from the previous version of the tool.

TSS-2853
Azure Managed Instance Creating a Symmetric Key, Asymmetric Key, and Certificate under the Security section is not supported for Azure Managed Instance with Microsoft Entra Service Principal authentication. TSS-2593
Azure Managed Instance Server compare functionality is not supported on Azure SQL Database and Azure SQL Managed Instance connections. TSS-2592
Azure Managed Instance Azure SQL Managed Instance does not support creating an assembly from a file. TSS-2591
Azure Managed Instance The option to copy or create like database from an existing database is not supported for Azure Managed Instance databases. TSS-2589
Azure Managed Instance The option to create a firewall rule at the server level under Server Security is not available for Azure Managed Instance databases. TSS-2588
Schema Comparison Report Schema Comparison Report is not displaying data under the Summary table. This issue is observed only when the user is logged in with Azure DB using SQL authentication. TSS-2537
Log reader help The Toad for SQL Server help page displays an error when users try to open the help for Log Reader. TSS-2532
Partition Scheme Users are not able to create a Partition Scheme for an Azure database because the File Group value is not displayed after selecting the Partition Function option. TSS-2465
General The To Editor and Append To Editor options are not working as expected when used from Execute Script under the Generate SQL menu. This issue is observed only when the user is logged in using multi-factor authentication. TSS-2435
Options menu Toad for SQL Server is disabling the Create Extended Stored Procedure... and UDDTs options when users clear the Show Toolbar checkbox under the Options menu. TSS-2429
Text Diff Viewer The responsiveness of the Toad for SQL Server application slows down when users compare assembly scripts in the Text Diff Viewer. TSS-2426
Editor Toad for SQL Server is displaying a syntax error in the editor when users attempt to open a SQL script to edit the permissions. TSS-2425
General Toad for SQL Server displays an error while creating an Asymmetric Key and Certificate for an MFA connection. TSS-2143
General Toad for SQL Server displays a subscription error when attempting to create UDDTs and tables in Azure Managed Instance. TSS-2142
General Toad for SQL Server does not support the Server Compare functionality for Azure SQL Database and connections using MFA (Multi-Factor Authentication). TSS-2140
General The Drop Stored Procedure option is not functioning properly for script options in the master database. This issue has been observed in Object Explorer > Master Database > Programmability > Right-click on any Stored Procedure > Generate SQL > Drop Script. TSS-2135
General The Optimize SQL Statement option is disabled in the editor for the Azure DB connection. TSS-2093
General When users attempt to generate an Azure DBA report using the Generate Detail Report option after completing a schema compare, Toad for SQL Server displays an error. TSS-2092
General Toad for SQL Server is generating an incorrect schema compare report for system data types. TSS-2088
General Toad for SQL Server displays a database error when creating a role as an Azure database user. TSS-2083
General When creating a new database, Toad for SQL Server displays a syntax error in the editor for a valid database script. TSS-2077
General Toad for SQL Server displays an error when users use the TO_Date function in the WHERE clause. TSS-2035
General The Reports Manager displays the database error while generating the table reports of non-indexed tables. TSS-1758
General Toad for SQL Server is not displaying any matching files when searched using the Find and Replace option. TSS-1757
General Toad for SQL Server is not displaying the list of active servers while creating a new database connection. TSS-1756
General The Manage License and Exit Application buttons on the Toad for SQL Server – All Licenses Expired window are not aligned properly. TSS-1755
General Toad for SQL Server gets hanged when users try to start service for a database from Microsoft SQL Server from the Connection Manager pane. TSS -1749
General Users are not able to access the SQL Azure portal URL when navigated from Toad for SQL Server. TSS -1747
General The Certificate field on the Alter Database Encryption – TestDB window is not displaying any option to select while using the Encrypt Database functionality. TSS -1729
General Toad performs the backup operation of the database successfully but the backup file (.bak) is not available at the backup destination provided in the script. TSS -1728
General When users work in the Editor mode, most of the options under the Edit menu are disabled, however, users are able to use those options through keyboard shortcuts. TSS -1726
Drag and Drop Objects Users are unable to edit the default action for any object under the Drag and Drop functionality. TSS -1724
General Users are not able to convert the PLI Application code to SQL code using the code conversion functionality. TSS -1718
SQL Script Generation Toad for SQL Server is not generating the correct SQL script while comparing data from two tables in the same database. This issue is observed when there is a difference in the data of two tables. TSS -1717
General When users delete the duplicate entry from the table, Toad does not commit the delete operation and displays the concurrency violation error. TSS -1716
General Toad for SQL server is facing an issue while opening the SQL Azure portal in a new tab within the application. TSS -1715
Debug and Run Toad for SQL Server displays an error while setting up the Debugger wizard TSS -1711
Execution Plan The Include actual Execution plan option is not working as a toggle button for the Execution plan option when used from the shortcut panel in the Editor window. TSS -1710
General Toad Intelligence Central is not able to fetch results for host name even if users search with the valid host name. TSS -1708
General Toad is displaying an error when users start tracing the activity of the application. TSS -1707
General Toad for SQL Server displays an error when users open the Always On Monitor screen. TSS -1703
Import and Export Users are not able to open the template in the editing mode on Import Wizard. TSS -1701
General If any Select SQL query has more number of rows in its output than the set Fetch Rows Limit, the output displays results only till that Select query. The Fetch Rows Limit is not applied on every output individually. TSS -1698
Statistics Tab in View Details Toad for SQL Server is not displaying the Statistic Log details for any table selected from the object explorer in the Statistics tab. TSS -1697
Startup/Installation If intending to hibernate the machine with the open connections to the servers that might be unavailable at the next startup, it is recommended to disconnect first due to risk of data loss.

 

N/A

 

Code Completion Code Completion provides limited syntax support of SELECT * INTO clause. ST87112
Connection Manager

Cannot establish Named Pipes connection if "Poll service status in connection list" option is selected.

Workaround:

Clear "Poll service status in connection list" checkbox on the Tools | Options | Database | General page.

ST86603

You need to install Microsoft Active Directory Authentication Library (adalsql.msi) to connect to Azure SQL Database using Active Directory Password Authentication.

QAT-14556
Data For some queries, attempting to right-click a row and select Row Count results in a message stating that the row count could not be determined. N/A
Performance Monitor You may encounter an exception in the Performance Monitor during recording: in the Object explorer expand and collapse a tables list. 930
You may encounter an exception when using the Performance Monitor and Session Browser at the same time. 948
Schema Compare When the Ignore column order option is not selected two tables are incorrectly reported to be equal. 245
The script comparing two databases where one database is empty has execution errors. 271
The script synchronizing two databases that have the same table with different index is incorrect. 834
Debugger You may encounter some issues when debugging remotely. ST82044
Editor Toad may hang after applying Short Format Uppercase Keywords or Short formats to large scripts.

ST83268

Execution Plan

You cannot generate an estimated execution plan for queries containing local temporary tables because the execution plan uses a different connection to generate the plan and does not know about the temp table.

Workaround:
Use the actual execution plan button to generate execution plans for SQL that contains a temp table.

N/A
Export Wizard/ One Click Export

Limitations when exporting fractional seconds:

  • When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported.

  • When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.

N/A

Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit.

N/A

Job Manager SQL Azure connections currently display in the Job Manager even though the Job Manager is not available for SQL Azure. ST75721
Log Reader User information only displays for operations in the sessions that are currently open. Backups do not contain this information because only the SPID information is available to them.

ST37112

SQL Azure connections currently display in the Read Log wizard even though the Log Reader is not available for SQL Azure. ST75720
Object Explorer/ Database Explorer

Table and Index Partitioning:

  • Currently, you cannot create or manage a partition on a table or index that includes a FileStream column.
  • Currently, estimating index compression savings runs a full table compression savings query, so the estimation may be slow on large tables.

ST59194

ST68131

FDCC: User cannot start/stop SQL Agent running Toad with Regular or Admin User account on the client side in some limited environments.

Workaround:

Start the SQL Agent on the server side.

ST91618

 

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating