Toad^® for SQL Server

Version 5.6 (Click here for previous versions)

Release Notes

November 07, 2011

Contents

Welcome to Toad

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.

Back to Top

New in This Release

New Features in 5.6

General

• For better usability some tabs in the View Details pane (DOV - Database Object Viewer) were united:
  • "Foreign Keys", "Referenced by" and "Check constraints" tabs are grouped under the unite "Constraint" tab. You can enable and disable objects within this tab.

  • Information previously stored in "Uses" and "Used by" tabs is now displayed in "Dependencies" tab as a tree. Toad now displays dependencies more accurately.

    

• The cursor is now automatically set to the first item in object list ones you select a type of objects from the list in the Object Explorer (when non-treelist views are enabled). For example, if you occasionally scroll the mouse the type of objects you selected won't get out of site.

• You can copy data in the property grid on DOV (Database Object Viewer) that is available with right-click | View Details in the Object Explorer.

  

• Specially for Toad for Oracle theme users! As in Toad for Oracle now you can open the Objects Details pane with a single F4 click on the object in the Object Explorer.
• Fixing multiple issues improved Toad performance. Now Toad works more stable and the operations are less time-consuming.

Database Administration

Object Explorer

• Multiple issues with filters in the Object Explorer were fixed. Use filter to find required objects faster.

• Schema bounded objects (functions and views) are now highlighted green in the Object Explorer.

• The context menu is available for each individual object and for the multiple ones. Right-click one or several objects in the Object Explorer and enable required functions.

• You can manage columns directly from the Columns pane at the bottom of the Object Explorer. Select the table in the Object Explorer, right-click a column name to alter or rename it, bind to rule or default or create an index.

  

Object Management

• Toad incorporated group execution in DOE (Database Object Editor) that allows to easily apply security changes (Users, Logins, Passwords etc) across the multiple servers.

  

• Now you can review the drop impact on dependencies when removing database objects. View the list of dependent or referenced objects that would restrict the object from dropping or would be dropped along with it or become inoperative.

  

• Now SQL generated in the Object Editor dialog (SQL Script tab) is formatted with default format settings.
• Toad provides improved management of the tables and especially columns:

  • Now you can sort the columns by their actual order in the Columns tab of the Tables and Views Object Details pane (DOV - Database Object Viewer).

    

  • Within the Columns tab you can create indexes based on the columns selected in the list.
  • You can rename the columns in the table.

  • You can set the default column type in table DOE by pressing pin button next to drop-down list of available data types.

    

• Index managing functionality has significantly extended:

  • You can create an index on table or view from the context menu.

  • Indexes now can be enabled and disabled from the context menu.

    

  • When creating an index with a help of DOE (Database Object Editor), you can select and add views from the list along with tables. Click view icon to select a view as a parent object and select required name from the list. If you have too many objects in your database – define filter before opening drop-down list.

    

Connection Manager

• Toad now can connect to Central Management Server to get the list of connections.

  

• Encrypt option is now available in the connection's properties.

  

• New Advanced tab helps you to manage connections. You can specify the protocols and network package size.

  

• You can assign categories to connections via context-menu. Right-click a connection or group and select one of the predefined categories or create your own one. You can also change categories of several connections simultaneously in the Connection Manager pane.

  

Query Development

Code Completion

• The overall performance and stability has improved.
• Code Completion window design has slightly changed.

• "Merge secondary items" option was renamed to "Include rarely used objects".

• When typing GROUP BY the columns are automatically offered for grouping.

• Code Completion now supports CTE syntax. You can declare CTE. Your defined CTE is included into code completion list and you can select it for your queries. Code Completion also advises you on columns included in CTE.

  

• The code completion list is filtered while you are typing that helps you to find required objects faster.

  

Editor

• Select the block of code in the Editor, right-click it and select Create stored procedure. You can also click stored procedure icon in the Editor toolbar. Toad automatically recognizes procedure's body and declared parameters in the invoked Stored Procedure creation dialog.

  

• Changing database for the current connection in the Editor toolbar became easily. Just start typing database name, not paying attention to the case, as it is case insensitive now.

Result Sets tab

• The Result Set automatically generates names for the unnamed columns.

• XML is now supported, including copying XML documents into new Editor tabs, formatting, XML document highlighting and saving to file. The results returned after running FOR XML PATH queries are conveniently organized in the Result Sets pane and can be easily reviewed when scrolling them down.

  

Data Management

Create Snapshot

Create Snapshot functionality is now supported. You can take a snapshot, revert to a snapshot and it.

Unlike backup a snapshot requires less hard disk space and is recommended for report purposes.

Index Fragmentation

The process of index defragmentation became more customizable. To avoid time-consuming and excessive IO you can now set one of the scanning modes:

• Limited (use this one to get the results faster)
• Sampled
• Detailed

Version Control

Toad now provides basic support of TFS 2010.

For TFS 2010, specify the server where your version control provider is installed and the port number (default is 8080) to use in the following format:

http://MyServer:Port/TFS

Back to Top

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release.

Back to Top

Known Issues

The following is a list of issues known to exist at the time of this release.

Back to Top

Third Party Known Issues

The following is a list of third party issues known to exist at the time of this release.

Back to Top

System Requirements

Client Requirements

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

Server Requirements

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

Virtualization Support

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 run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

  1. Select Control Panel from the Windows Start menu.
  2. Double-click Administrative Tools.
  3. Double-click Microsoft .NET Framework version Configuration.
  4. Select My Computer, and then select the Runtime Security Policy node.
  5. Select Evaluate Assembly from the list of tasks in the right panel, and locate and select Toad.exe in the File field.
  6. Click Next and set the permission to Unrestricted.
• 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.

Back to Top

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

This release has the following known capabilities or limitations: No known limitations.

Back to Top

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

1. Toad for SQL Server 5.6
2. Product Documentation, including:
   • Installation Guide
   • Online Help
   • Release Notes

Installation Instructions

See "Toad for SQL Server Installation Guide" for more information.

Back to Top

For More Information

Contact Quest Software

See our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to SupportLink, our self-service portal. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

• Retrieve thousands of solutions from our online Knowledgebase
• Download the latest releases and service packs
• Create, update and review Support cases

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, policies and procedures. The guide is available at: http://support.quest.com.

Toad Community

Get the latest product information, find helpful resources, and join a discussion with the Toad for SQL Server Quest team and other community members. Join the Toad community a http://toadforsqlserver.com/index.jspa.

Back to Top

© 2011 Quest Software, Inc.

ALL RIGHTS RESERVED.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

www.quest.com
email: legal@quest.com

Refer to our web site for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, LiteSpeed, SQL LiteSpeed, Toad, T.O.A.D., Toad World, and vToad are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. For a complete list of Quest Software’s trademarks, please see http://www.quest.com/legal/trademark-information.aspx. Other trademarks and registered trademarks used in this guide are property of their respective owners.

Back to Top