Chat now with support
Chat with Support

Toad for SQL Server 6.8 - Editions Installation Guide

Toad Editions

About Toad Editions

By purchasing one of the Toad for SQL Server Editions, you have obtained not only a powerful SQL Server application development tool, but other tools to help you maintain and develop your SQL Server database applications.

This guide is an executive overview of the Toad for SQL Server Editon. It provides basic information about installing the products, including system requirements and the use of the Quest Software Installer. See the specific Installation Guide for each product for more information about each application, including troubleshooting information.

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

Notes:

  • 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.

System Requirements

Client Requirements

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

Platform

2 GHz processor (recommended minimum)

Memory

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®

Additionally

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

Requirements:

  • 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 http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx 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. http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en

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 http://msdn.microsoft.com/en-us/library/ms162189.aspx. You can also simply install Management Studio from SQL Server installation media.

Repository

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