Chat now with support
Chat with Support

Toad for SQL Server 7.1 - Release Notes

Toad for SQL Server 7.1

Toad for SQL Server 7.1.x

Release Notes

Monday, November 18, 2019

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.

Toad for SQL Server 7.1.2 is a patch release with new features, security enhancements and resolved issues.

New Features

New Features

In Toad for SQL Server 7.1 the following new features were implemented:

Security and Installation Enhancements

For this release of Toad for SQL Server we have provided internal security adjustments. We have revised a list of third party components in use according to their known and potential vulnerabilities. Toad uses only reliable and safe components by third party vendors. See the list of third party components in Toad for SQL Serverthe help file, section About Us | Third Party Components.

Our Toad installers are now based on the Wix Toolset , which improves user experience and performance of the installation process.

See Resolved Issues for more enhancements and resolved issues in this release of Toad for SQL Server.

Learn More

Get the latest product information, find helpful resources, and join a discussion with the Toad for SQL Server team and other community members. Join the Toad for SQL Server community at Toad World.

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® 2008 R2 SP2

Windows Server® 2012

Windows Server® 2012 R2

Windows Server® 2016

Windows Server® 2019

Windows® 7 SP1 (32-bit or 64-bit)

Windows® 8.1 (32-bit or 64-bit)

Windows® 10, version 1809

Important: Toad uses the Microsoft® Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Server 2008 and Windows 7. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.

.NET Framework

Microsoft® .NET Framework 4.7.1

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 11 or later

Screen

Toad supports screen resolutions up to 3200 x 1800 and display DPI settings up to 150%

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 2012 and SQL Server 2012 Express

SQL Server 2014 Enterprise and SQL Server 2014 Express

SQL Server 2016

SQL Server 2017

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.

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.

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

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

Resolved Issues in 7.1.2

Feature Resolved Issue / Enhancement Defect ID
Dimensional Viewer

We have improved work with calculated fields and aggregate values in Dimensional Viewer

QAT-15139
General

Collation property while importing data using Automation script has been modified to improve performance with certain JOINS on Tables

QAT-15314/4572415
Object Explorer

Issue with a public login has been resolved

TSS-1660/4473466
Space Management

Disk Management in Toad SQL Server now shows correct number of disks

TSS-1665/4528319, 4545812
Team Server

Publishing a script with different schemas from the same database now works correctly

QAT-15319/4534571

Resolved Issues in 7.1

Feature Resolved Issue / Enhancement Defect ID
Code Completion Dragging and dropping column names from Object Explorer to Editor now works correctly. QAT-15117
General Fixed some issues with disappearing buttons on Win 10. TSS-1661/4448709
Pivot Grid Pivot Grid now allows you to use Aggregated data values in a calculated field. QAT-14558/4415769
Query Builder You now can select LAG and LEAD in the list of functions for calculated fields in Query Builder. QAT-14252/4438857
SQL Editor Highlighting keyboard shortcuts now work correctly in Editor. QAT-15111/4542078,   4555409,  4559368,   4564671  
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