Chat now with support
Chat with Support

Toad for SQL Server 6.8 - Editions Release Notes

Release Notes

Version 6.8

Release Notes

Thursday, August 10, 2017

Welcome to Toad for SQL Server Editions

Each Toad for SQL Server Edition is packaged with additional Quest Software products to expand your SQL Server experience. The following editions are available:

Toad for SQL Server Commercial

  • Toad for SQL Server
  • Quest SQL Optimizer for SQL Server

Toad for SQL Server Developer Edition Commercial

  • Toad for SQL Server
  • Quest SQL Optimizer for SQL Server
  • Benchmark Factory for Database
  • Toad Data Modeler


  • Your license key determines the edition and will enable the functionality accordingly. In many cases, if functionality is disabled within Toad for SQL Server Edition, you may not have an appropriate license to use it. When Toad is running, you can see which components are licensed by selecting Help | About.
  • When running the Quest Software Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message. Select This program installed correctly to continue installation. For more information, see
  • When installing commercial Toad for SQL Server bundle after trial Toad for SQL Server bundle, the commercial bundle recognizes a license key from the trial bundle and expires the same date as the trial bundle's key. To continue working with the commercial bundle please input a valid (commercial or new trial) license key.
  • In this release of Toad for SQL Server Editions, uninstall edition products using the Windows Control Panel | Programs and Features. There will be no uninstall shortcut on the Windows Start Menu.

New Features

New in This Release

  • Disk Space checking is added to "Progress" for each product install.
  • The Error Message box has been redesigned to handle installation exception errors.

To view what is new in each product, see the release notes for each individual product.

Product Release Notes

Toad for SQL Server 6.8.0

Quest SQL Optimizer for SQL Server 10.0.3

Benchmark Factory for Database 7.6.1

Toad Data Modeler 6.2.0

Quest Installer 3.1.0

System Requirements

Client Requirements

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


2 GHz processor (recommended minimum)


4 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

By Toad Edition

  • Toad for SQL Server—174 MB
  • Toad for SQL Server Developer Edition —294 MB

By Product

  • Toad for SQL Server Professional, Xpert—104 MB

  • SQL Optimizer for SQL Server—70 MB of disk space to run SQL Optimizer
  • Benchmark Factory – 120 MB of disk space for installation. The disk space required may vary based on options selected for installation.
  • Toad Data Modeler — 400 MB minimum , 1 GB recommended.

Operating System

Windows Server® 2012

Windows Server 2008

Windows Server 2003

  • Toad for SQL Server and Benchmark Factory only.

Windows 10

  • Toad Data Modeler only supports Windows 10 64bit.

Windows® 8.1

  • SQL Optimizer for SQL Server supports Windows 8.1 Enterprise (with Update)
  • Benchmark Factory supports Windows 8.1 (with Update).
  • Toad Data Modeler supports Windows 8.1 PRO (64-bit).

Windows 8 (32-bit and 64-bit)

  • Toad Data Modeler supports Windows 8 PRO.

Windows 7

Windows Vista®


Windows Server 2016

  • SQL Optimizer for SQL Server

Windows Server 2012 R2

  • Toad for SQL Server supports Windows Server 2012 R2.
  • SQL Optimizer for SQL Server supports Windows Server 2012 R2 (with Update)

Windows Server 2008 R2 (64-bit)

  • Toad for SQL Server supports Windows Server 2008 R2 Service Pack 1 (64-bit)
  • Toad Data Modeler


  • The 32-bit version of Benchmark Factory requires the 32-bit versions of the client libraries (including ODBC drivers). The 64-bit version requires 64-bit client libraries.

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 Vista, 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 for more information about enabling DTC access.

.NET Framework

Microsoft .NET Framework 4.5.1.

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 7.0 or later

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.

Copy/Move Database Wizard

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

PDF Viewer

Adobe® Acrobat® Reader 7.0 or later.

SQL Server Management Objects (SMO)

SQL Optimizer for SQL Server requires SQL Server Management Objects; for more information about SMO, please visit You can also simply install Management Studio from SQL Server installation media.


Benchmark Factory cannot run without a repository, and during installation you must select either the default service based or file based repository. For more information see the Benchmark Factory Release Notes.

Server Requirements

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

Database Server

SQL Server 2016 is supported by Toad for SQL Server

SQL Server 2014 Enterprise and SQL Server 2014 Express

SQL Server 2012 and SQL Server 2012 Express

SQL Server 2008 R2 and SQL Server 2008 R2 Express is supported by Toad for SQL Server

SQL Server 2008 and SQL Server 2008 Express

SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express

SQL Server 2000 (Service Pack 3 or later)

Note: The following features are not available in Toad for SQL Server running on SQL Server 2000:

  • Index Defragmentation
  • Storage Management
  • Performance Monitor
  • Spotlight Essentials Performance Analytics
  • Altering procedures, functions, views in the Editor
  • Version Control

Requirements and exceptions:

  • SQL Server Compact Edition is not supported.
  • SQL Optimizer explicitly supports SQL Server 2016 and 2017 and has been tested against SQL Server 2017 running on Windows or Linux. SQL Optimizer does not support SQL Server 2012 Express and SQL Server 2014 Express.
  • Toad for SQL Server explicitly support SQL Server 2008 R2 and SQL Server 2008 R2 Express.
  • Benchmark Factory explicitly supports SQL Server 2008 R2.
  • Benchmark Factory explicitly supports SQL Server 2016.

Cloud Database Service

Toad for SQL Server and SQL Optimizer support Microsoft SQL Azure™ Database. Benchmark Factory provides limited support of SQL Azure.

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

Toad Data Modeler and Benchmark Factory support Oracle Database as a Service.

Virtualization Support

Application Virtualization

Toad for SQL Server - Limited testing has been performed for:

  • Citrix® XenApp™ 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.
  • Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

SQL Optimizer has been tested with:

  • Citrix XenApp 5.0 on Windows Server 2003 (Service Pack 2) using the Citrix Presentation Server Clients 4.0
  • Citrix XenApp 6.5 on Windows Server 2008 R2.

Benchmark Factory has been tested with the following:

  • Citrix XenApp 6.5

Toad Data Modeler has been tested for:

  • Citric support on the Citric XenApps 6.5 Server.
Desktop (VDI)

Toad for SQL Server has been tested with vWorkspace™ 7.6 running on Windows Server 2008 R2 64-bit.

Toad Data Modeler has a problem during print on virtual printer - The problem occurs only in case of print from local machine (all printers from local machine are visible on vWorkspace). If the virtual printer is installed on Workspace directly, the problem doesn't occur.

Server Toad Data Modeler has been tested with VMware Server 2 running on Windows 7 and Oracle VM 3.0

Note: Toad may work in virtualization environments other than the ones in which it was tested.

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, Vista standard 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.
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