Chat now with support
Chat with Support

Toad for SQL Server 6.8 - Installation Guide

Files Migrated During Upgrades

When upgrading to a new version of Toad, the following files can be migrated from the previous version's Application Data Directory (click the Application Data Directory link in Help | About to open the directory).

Caution! Migrating settings from a previous version of Toad may overwrite new settings files, implemented for the current release (for example, updated reports templates, layouts, etc).

File

Description

Action.log

Tracks your usage within Toad. If you agree to share this data, the file is automatically sent to Quest Software on a periodic basis.

Connections.xml

Contains all connections stored in the Connection Manager or the New Connection window.

ConnectionTrace.log

Contains the SQL Output connection trace log file if you select Tools | Execution Trace from the menu.

ExceptionTrace.log

Contains a log of all exceptions encountered while running Toad.

FTPConnection.log

Contains a log of exceptions encountered when attempting to connect to FTP servers.

FTPConnections.xml

Contains connections to FTP servers stored in the FTP Connections window.

Quest.PersistentCache.xml

Contains the private object annotation cache options (object notes, Lookup tables, and hidden columns). You can share these options with other Toad users in Tools | Options | Database | Cache.

Settings.xml

Contains many of the global configuration settings.

SqlServerPlanPrefs.xml

Used to generate SQL Server execution plans.

ToadSupportBundle.zip

Contains the last support bundle you generated.

Folder

Description

Automation (temporary folder)

Used by automation when executing automation scripts.

Cache

Used to spool cache database metadata to disk if enabled. The data is in binary format and can always be recreated by fetching it from the database.

Context

Contains settings that depend on the context within Toad including the following:

  • Adapter—Custom data editing statements.

  • Filter—Unnamed filters defined in the Object Explorer or Database Explorer.

  • Named Filter—Named filters defined in the Object Explorer or Database Explorer.

  • TYPE—Tabs that display on the right when you select an object in the Object Explorer or Database Explorer.

Document Recovery

Contains backup copies of Editor, Query Builder, and Database Diagram files saved if you have enabled Document Recovery in Tools | Options | Environment | General.

Keyboard

Contains custom keyboard shortcut layouts.

Layouts

Contains layouts for some areas in Toad, such as tool windows that automatically display in the Editor and column layouts for the Messages tab.

ModuleSettings

Contains general settings for various components in Toad, such as whether the data grid defaults to read-only, displays not null indicators, etc.

Plugins

Used by Toad plugin components.

Session

Contains desktop configurations, including toolbar customizations and tool window locations.

SQLFormatter

Contains pre-set and user created templates for formatting SQL, and the SQL statement used to preview formatting changes in the Formatting Options page.

SQLRecall

Contains the SQL statements saved by SQL Recall.

Templates

Contains the following templates:

  • Code Templates—Templates used to define default values when creating new objects in the Object Explorer or Database Browser.

  • Scripts—Startup scripts to run when connecting (InitialSqlServer.Sql).   

  • Snippets—Code Snippet entries.

  • Reports—Report entries.

Integration between Toad and Microsoft SQL Server Management Studio

Toad provides a plug-in that integrates Toad features with Microsoft SQL Server Management Studio. Enjoy the advantages of both products and ease of communication. The Toad Plug-in is installed as a part of the Toad for SQL Server installation process and supports the following versions of Management Studio:

  • Microsoft SQL Server Management Studio 2017
  • Microsoft SQL Server Management Studio 2016
  • Microsoft SQL Server Management Studio 2014
  • Microsoft SQL Server Management Studio 2012
  • Microsoft SQL Server Management Studio 2008 R2 SP2 or later

The Toad Plug-in allows you to invoke key Toad features right from the Management Studio context menu and to send data directly into Toad. Connection information and security settings are transferred automatically and Toad functionality is already up and running.

Depending on the Toad Edition you are running, the following Toad features can be invoked from Management Studio:

  • Group Execute
  • Automation
  • Log Reader
  • Data Compare
  • Schema Compare
  • Importing and Exporting Data
  • Session Browser
  • Performance Monitor
  • Index Fragmentation
  • and etc.

Note: If you have several editions of Toad for SQL Server installed side-by-side (for example, Beta, Trial and Commercial) and you uninstall one of them, Toad Plug-in files are removed as a part of un-installation process. See Troubleshoot SQL Server® Issues for more information about how to manually restore Toad Plug-in.

Install and Uninstall Toad Plug-In

Launch SsmsInstallation.exe from the Windows command prompt as administrator.

  1. Open SSMS Installation directory (<Toad install directory>/ SSMS Installation) from the Windows command prompt.
  2. Enter the following:

    SsmsInstallation.exe [Type of Product/Mode] "[TSS Installation Directory]"

    Where:

    [Type of Product/Mode] can be Uninstall, Freeware, Beta, Commercial, Trial

    [TSS Installation Directory] is the directory where Toad for SQL Server resides.

Example:

C:\Program Files (x86)\Quest Software\Toad for SQL Server 6.8\SSMS Installation\SsmsInstallation.exe Commercial "C:\Program Files (x86)\Quest Software\Toad for SQL Server 6.8"

Uninstall Toad

If you uninstall Toad, it may not uninstall completely. When you use Toad, you create new files such as SQL scripts, data output, or temp files, etc. The following types of files are not removed when you uninstall:

  • Any new files you create
  • Any copies of files you make for backup purposes
  • Settings files

You can uninstall Toad for SQL Server by using the Windows install/uninstall programs feature.

To uninstall Toad

  1. Open the Windows Control Panel and select Programs and Features.
  2. Select the product that you want to uninstall.
  3. Click Uninstall.

Licensing

To enter your license key

  1. Select Help | Licensing from the menu (ALT+H+L).

  2. Review the following for additional information:

    Authorization key

    Enter the license key for Toad.

    Site message

    Enter the site message included with the license key.

    Note: Your license key determines the edition of Toad  (Pro, Xpert, etc.) and will enable the functionality accordingly. In many cases, if functionality is disabled within Toad, 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. For complete list of features shipped with your Toad edition see http://www.quest.com/.

Notes for Toad for SQL Server Users

Trial Keys

The commercial version of Toad for SQL Server comes pre-installed with a trial license key for your convenience. This allows you to use the application while waiting for your commercial key to be delivered.

The trial license key remains active for the designated trial period, even after you enter your commercial license key (the splash screen may continue to indicate your application is a trial version). This is helpful if you are previewing an upgrade or an advanced module.

Important: 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.

If you entered your commercial license key and do not require the trial version, you can delete the trial key.

Important: If you delete the Trial key, any advanced features not included in your purchased edition will be disabled.

To delete a trial key

  1. Select Help | Licensing.
  2. In the Toad Licensing dialog, select the License tab for the trial license key and then click Delete License to delete the trial key.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating