Release Notes
Tuesday, July 23, 2024
Contents
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.
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:
|
|
Hard Disk Space |
800 MB to install Toad Note: The disk space required may vary based on the edition of Toad selected for installation. |
|
Operating System |
Windows Server® 2022 Windows Server® 2012 Windows Server® 2012 R2 Windows Server® 2016 Windows Server® 2019 Windows® 8.1 (32-bit or 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.
|
| .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. |
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
| Requirement | Details |
|---|---|
|
Database Server |
SQL Server 2022 SQL Server 2012 and SQL Server 2012 Express SQL Server 2014 Enterprise and SQL Server 2014 Express SQL Server 2016 SQL Server 2017 SQL Server 2019 Notes:
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.
|
| 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. |
| 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. |
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:
The following describes the requirements and restrictions for users who launch and run Toad:
| Enhancement ID | Description |
|---|---|
| TSS-2189 |
We are introducing Toad for SQL Server Xpert Plus, a new edition developed to provide enhanced features and capabilities for SQL Server users. For a detailed comparison of Toad for SQL Server editions, please see Toad for SQL Server metrix comparison. The Toad for SQL Server Xpert Plus edition includes additional software such as SQL Optimizer and ApexSQL. In this edition, we have implemented subscription support to ensure all assets are available for subscription sales. |
| TSS-2188 | Toad for SQL Server now displays in-app messages informing users that they are entitled to product assets for additional software, and allows them to quickly download and use the tools from the Toad for SQL Server UI controls. |
| TSS-2165 | When users restart the Toad for SQL Server application with an active number of editor tabs within the user interface, those tabs open automatically and are available upon restart. |
| TSS-2164 | Run query option in the Context Editor menu: Users can now execute SQL scripts within the Editor working pane from the Context menu. |
| TSS-2096 |
Toad for SQL Server now supports the Azure SQL Managed Instance Cloud database using the following authentication types:
Limitations: The following features/functionalities are not supported:
|
| Enhancement ID | Description |
|---|---|
| TSS-2000 |
Data compare now provides users with the below extended filter capabilities:
|
| TSS-1991 | Toad for SQL Server's application user interface, including UI elements, will by default be displayed in dark mode, more precisely in DevExpress Dark Style. |
| TSS-1989 | Users now have the option to close all existing connections on the targeted database when performing the Restore Database operation. |
| TSS-1984 | The Code Completion window now opens at the upper side when the cursor is at the bottom of the screen. |
| TSS-1983 |
Alias Length: Select the appropriate alias length control option (this option is available only when the "Find upper case characters" option is selected):
|
| TSS-1982 |
Configure Options: Show Code Completion on Boolean Field: Select this checkbox to view the code completion suggestions for boolean fields. Clear this checkbox to hide the code completion suggestions for boolean fields. Default: Selected |
| TSS-1981 | The code completion suggestion pop-up window now also appears on a new line with tabbed spacing. |
The following is a list of issues addressed in this release of Toad for SQL Server:
| Feature | Resolved Issues | Defect ID |
|---|---|---|
| Editor | The Auto-replace option under the Editor menu is not working as expected when the application is used in DevExpress Dark Style mode. | TSS-2564 |
| Dark Office 2016 | Users are not able to save the highlighted color for any text using the Dark Office 2016 skin tool; the highlighted text color changes back to black. | TSS-2163 |
| Object Explorer | When users click on the Last Updated column in the tables list in Object Explorer, the tables list gets cleared. Users then have to restart the application to see the list of tables again. | TSS-2162 |
| Drag and drop | Users are not able to rearrange the existing saved connections within the group using the drag-and-drop functionality. | TSS-2161 |
| Azure SQL database | When importing data from Excel to Azure SQL database, the query processor ran out of internal resources and could not produce a query plan. This issue occurs when importing data into a table with over 1.6 million records using a spreadsheet containing 10,000 or more records. | TSS-2160 |
| Security Migration | The Security Migration wizard is not functioning as expected. After selecting the target databases, the Next button becomes disabled. When the target databases are deselected, the Next button becomes enabled. | TSS-2153 |
| TIC connection | Toad for SQL Server is not displaying the TIC connection in the Import Connections wizard, under the Available Connections/Group section. | TSS-2152 |
| Licensing | The License Details and About windows display a negative number of days in the License Remaining Days section instead of indicating that the license has expired. | TSS-2146 |
| SSMS plugin |
Users can launch the Toad application from the Tools menu in the latest Microsoft SQL Server Management Studio versions 19.x and 20.x. Limitation: Support for Context menu options 'Toad Manage' and 'Toad Optimize', available via right-clicking, will be added in the Toad for SQL Server 8.2 release. |
TSS-2097 |
| Optimize the current statement | When users enter a valid statement in the editor, the Optimize the current statement option is not enabled. This issue is observed in the SQL Server 2022 database environment. | TSS-2093 |
| Editor | The TSS source code editor and code formatter do not support the select sysutcdatetime() at time zone 'UTC' at time zone 'Pacific standard Time' query. |
TSS-2065 |
| Objects | Toad for SQL Server is not displaying the objects for all referenced tables in the Object list of the nested query. | TSS-2064 |
| Extended property |
When users create, add, or delete an extended property for a user in a database (security/users), the generated code defines the extended property on the 'schema' instead of the 'user,' and Toad for SQL Server displays an error if the user doesn't have an existing schema.
|
TSS-2001 |
| Job Schedule | Users are not able to update the job schedule using Toad for SQL Server. | TSS-1996 |
| Configuration Wizard | A few options under the Layout and Settings section in the Configuration Wizard window are not fully visible. This issue is observed on Windows 11. | TSS-1994 |
| General | The application is not opening a new tab after establishing a database connection, even when the Open on New Connection option is checked. | TSS-1988 |
| Binary comparison keys | Users are not able to compare two binary comparison keys using Toad for SQL Server. | TSS-1797 |
| General | The Save and Cancel buttons, used to save or cancel queries, are disabled. | TSS-1788 |
| Log reader export | A few log reader export options are missing in Toad for SQL Server 7.4. | TSS-1787 |
| Index | Users are not able to create a clustered or non-clustered index using Toad for SQL Server. | TSS-1774 |
| Schema Compare | Toad for SQL Server is not displaying the search text box for advanced search in the Schema Compare window. | TSS-1696 |
| Code Snippets | When users restart Toad for SQL Server and open the Code Snippets window, all the folders appear expanded. | TSS-1447 |
| Feature | Resolved Issues | Defect ID |
|---|---|---|
| General | On the initial startup of the Toad for SQL Server application, the query runtime may take up to five minutes to complete for the first query. | TSS-1987 |
| General | Toad for SQL Server does not allow comparison between the editor sets in its 7.4 version. | TSS-1962 |
| General | Users are not able to log in to the SQL Azure database in the Azure environment using Toad For SQL Server when MFA / 2FA is enabled. | TSS-1925 |
| General | The SQL 2019 option is not available to set the database compatibility level on the database in the Toad for SQL Server application. | TSS-1918/ TSS-1692 |
| General | When connecting to an SQL Azure database, Toad for SQL Server displays an SQL Server Database Error. This issue is observed when a temp table is included in the SQL statement. | TSS-1913 |
| General | Toad for SQL Server displays an error when users open the TSM files using Azure SQL Server. | TSS-1781 |
The following is a list of issues known to exist at the time of this release.
|
Feature |
Known Issue |
Defect ID |
|---|---|---|
| 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: |
N/A |
| Export Wizard/ One Click Export |
Limitations when exporting 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:
|
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 |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
