Release Notes
Wednesday, August 9, 2023
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.
Toad for SQL Server is now available with subscription licensing.
The benefits of subscription include:
All the great award-winning Toad features you have grown to love
Access to our world-class support team, Knowledge Base, how-to videos and more
Online License Management making it easy to assign licenses to individuals, keep track of individual usage, manage organizations, and reassign unused or under-used licenses as needed to ensure license compliance
Automatic Renewal ensuring that Toad for SQL Server Pro Plus Subscription Edition will be continuously available to users
Access to ApexSQL Source Control, an SQL Server Management Studio (SSMS) add-in, provides version control for SQL databases and objects. It seemingly integrates with all major source control systems, enabling database developers to collaborate in shared development environments.
Note: Currently only the Toad for SQL Server Pro Plus Subscription Edition is available.
The following products may be part of your Toad for SQL Server non-Subscription Edition:
Toad for SQL Server
Benchmark Factory for Databases
Quest SQL Optimizer for SQL Server
Toad Data Modeler
The following Toad for SQL Server non-Subscription Editions are available:
| Edition | Licensed |
|---|---|
| Toad for SQL Server Pro Edition | Toad® for SQL Server® Professional |
| Toad for SQL Server Xpert Edition |
Everything in Toad® for SQL Server® Professional with Compare & sync schemas (1:many) SQL Optimizer for SQL Server® |
| Toad for SQL Server Dev Edition | Everything in Toad® for SQL Server® Xpert Plus |
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 and Azure SQL Data Warehouse 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 | Resolved Issues |
|---|---|
| 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:
Resolved Issues in 8.0
| 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 |
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center
