Version 1.0
Release Notes
July 2011
| Global Operations | Getting Started | For More Information |
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.
Use the Object Explorer to quickly locate objects of interest. You can also set a filter to further narrow the list of objects. Once you locate an object, you can use the right-click menu or toolbar to perform additional actions, and can double-click the object to open a pane that displays the columns, data, script, and other properties for that object.
To access this feature, select View | Object Explorer.
You can view session information, including the program name, status, executed command, physical IO, and memory usage for any connection using the Process Browser. You can also kill a process or send a SQL statement to the Editor. To access this feature, select Tools | Monitor | Process Browser.
You can view session information, including the program name, status, executed command, physical IO, and memory usage for any connection using the Session Browser. You can also kill a process or send a SQL statement to the Editor. This new Session Browser pulls data from MDA tables and provides more detailed information. To access this feature, select Tools | Monitor | Session Browser.
SQL Monitor
You can use SQL Monitor to view recently executed SQL for the entire server. To access this feature, select Tools | Monitor | SQL Monitor.
Error Log
The Error Log window monitors the monErrorLog MDA table and displays the most recent error messages from the Adaptive Server error log. To access this feature, select Tools | Monitor | Error Log Monitor.
Editor support for setuser command
Toads editor supports calling the setuser command before executing a SQL statement. This allows the database owner to impersonate another user. To access this feature, select Tools | Editor.
You can use the new File Transfer Protocol (FTP) utility to transfer scripts, reports, or other files from Toad. Toad supports unsecured (FTP) and secure (SFTP) file transfers. To open this utility, select View | FTP Connections from the menu.
The Editor includes additional features to increase your productivity. To access this feature, select Tools | Editor:
Quickly select from a list of tables,
columns, views, or other objects without having to manually enter
the object's name in the Editor using Code Completion:
Support for visual query plans:
View print statements in a message
output window:
You can create complex queries visually using the Query Builder. You can also reverse engineer a query from the Editor, or add a Lookup Table to a column for easy filtering. To access this feature, select Tools | Object Explorer.
Automate and schedule repetitive tasks using Automation. For example, you can schedule long running queries to execute during off-hours, export the results to Excel, and email a report automatically from a single script. To access this feature, select Tools | Automation.
Find database objects with ease using Object Search. To access this feature, select Tools | Object Explorer.
You can easily identify relationships between database objects with Database Diagram. To access this feature, select Tools | Database Diagram.
Quickly compare data on one or more servers and synchronize it using Data Compare. To access this feature, right-click an object and select Data Compare.
View RSS and Twitter feeds, including Toad Community postings from within Toad using Collaboration. To access this window, select View | Collaboration. Once open, you can click any entry to open the related content.
In the Collaboration window, you can click 
at
the top of the window to compose a new entry. You can select the
drop-down arrow beside the icon to select the feed to which you want to post.
To tweet, use the entry field at the bottom of the window. If you
click an item in the list, a reply tweet is entered in the field. If the
post contains a link, that link is opened in the Web Browser as well. To
post a tweet, press ENTER or click 
.
If you click 
,
you can toggle whether you want to include a screen shot of Toad with
your post (after posting, this option always reverts back to false).
Import data from a file, folder, or query using the Import Wizard. You can access this feature by selecting Tools | Import | Import Wizard.
Supported files types for the Import and Export wizard include CSV, Excel, text, and XML files:
Export data to CSV, Excel, Fixed Width, Delimited, XML, HTML, SQL Script, MS Access or a new table:
A script tab has been added for database devices.
If an ASE client is already installed and set up on your machine, Toad now looks for a SQL Interface file under %SYBASE%\ini\SQL.ini. If found, a drop-down populates and you can select a server to use with Toad.
Click
to
open the SQL Interface file and make changes if needed.
Integration with other Quest products
You can send a SQL statement in an editor to SQL Optimizer to find a more efficient version. To access this feature, select Tools | Quest Tools | SQL Optimizer.
You can also monitor performance on the server through the MDA table with SQL Optimizer Performance Monitor. To access this feature, select from Tools | Quest Tools | SQL Optimizer Performance Monitor.
If you want real time in-depth monitoring for your Sybase ASE server you can launch Spotlight for ASE. To access this feature, select Tools | Quest Tools | Spotlight on Sybase ASE.
The following is a list of issues known to exist at the time of this release.
|
Feature |
Known Issue |
Defect ID |
|---|---|---|
The following is a list of third party issues known to exist at the time of this release.
| Feature | Known Issue | Defect ID |
|---|---|---|
| Automation |
If you are running Windows XP with Service Pack 2 in strong security mode, Windows blocks you from opening zip files sent by Automation if they were created using the Windows Compression wizard. This is a security feature in Windows. Workaround:
|
ST49799 |
|
Excel |
If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662. |
ST42486 |
|
Export Wizard/ |
To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations: 2003 PIAs: 2007 PIAs: |
N/A |
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
|
Platform |
1 GHz |
|
Memory |
512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
|
|
Hard Disk Space |
|
|
Operating System |
Windows Server 2003 Windows XP Professional (32-bit Windows Vista (32-bit Windows Server 2008
(32-bit Windows 7 (32-bit or 64-bit)
|
| .NET Framework |
Microsoft .NET Framework 3.5 (Service Pack 1) Note: The following conditions apply:
|
|
Additional Requirements |
Web Browser Microsoft Internet Explorer 6.0 or later |
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
| Database Server |
- Sybase ASE 12.5, 15.0.2, 15.0.3, 15.5 - Sybase IQ 15.1, 15.2, 15.3 - Sybase SQL Anywhere 10, 11, 12 |
| Application Virtualization |
Limited testing has been performed for 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.
|
|
Note: Toad may work in virtualization environments other than the ones in which it was tested. |
|
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:
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:
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.
The Toad release package contains the following products:
See the Toad for Sybase Installation Guide for more information.
|
|
|
|
|
Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA |
|
Web site |
See our web site for regional and international office information.
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:
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.
Get the latest product information, find helpful resources, and join a discussion with the Toad for Sybase team and other community members. Join the Toad for Sybase community.
© 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
email: legal@quest.com
Refer to our Web site (www.quest.com) for regional and international office information.
Trademarks
Quest, Quest Software, the Quest Software logo, Benchmark Factory, 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.