Version: 2.0
Release Notes
March 20, 2013
Resolved Issues and Enhancements
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.
Resource limits allow a system administrator to set parameters to prevent queries and transactions from individual logins or applications from monopolizing server resources. Toad now has the ability to create, alter and drop these resource limits.
Job Scheduler gives you the ability to define and schedule database administration and maintenance tasks. You can create and schedule jobs and then share both jobs and schedules. Job Scheduler allows scheduled jobs to run with interaction from the database administrator. Toad now provides editors for creating, altering and dropping these jobs.
Enhanced graphical view of device allocations.
Apply system object filter for IQ and SQL Anywhere.
The performance monitor has been updated to allow for more statistical information.
There have been various enhancements to Schema Compare and Sync to improve functionality. You can now perform Schema Compare and Sync between Sybase ASE, IQ and SQL Anywhere.
The following is a list of issues addressed and enhancements implemented in this release.
| Feature | Resolved Issue | Defect ID |
|---|---|---|
| Debugger | Multiple editors no longer display when you debug a stored procedure. | ST104813 |
| Object Details | Dependency information now displays when you click on a rule. | ST96372 |
| You no longer receive an error when you send a create table script to the editor. | ST97255 | |
| Object Editor | Database objects sort alphabetically by default in Sybase ASE. | ST101402 |
| AliasEditForm now displays all available logins in Sybase ASE. | ST101404 | |
| You no longer receive an error message when you perform the Alter Table function in ASE 12.5. | ST104414 | |
| Object Explorer | Identifier names that are generated outside of the data dictionary no longer contain square brackets. | ST96342 |
| Script Generation | You can now generate the sp_unbindefault and sp_unbindrule when dropping defaults and rules. | ST93041 |
| User Interface | The name of the a rule's owner has been added to the sp_bind command. The setuser command displays if the table owner is not the same as the current user | ST96367 |
| You can now bind a cache to a specific table (sp_bindcache). | ST96369 | |
| You can now execute reorg rebuild from the table or index context menu in the object explorer. | ST96371 |
| Feature | Resolved Issue | Defect ID |
|---|---|---|
| Connection Manager | Toad no longer locks up or affects memory when connections timeout or go to sleep. | ST102243 |
| Object Editor (DOE) | You no longer receive error messages when you login using Sybase 12.5.0 | ST103249 |
| The Object Editor now generates an insert statement (Generate SQL | To Editor | Insert) without throwing a System.FormatException for date-based defaults. | ST103252 | |
| Query Builder | A .tsm file now opens correctly when you connect to a database. | ST103079 |
| Feature | Resolved Issue | Defect ID |
|---|---|---|
| Code Completion | The Editor can now identify a "Rules" object. | ST93552 |
| Connection Manager | Fixed issue with having multiple ASE servers on the same machine. | ST98322 |
| Export Wizard | You can now export a table to SQL Script and Create As New Table. | ST91689 |
| ER Diagrammer | There is a new Sybase option to enable you to create ER diagram links from an alternate source. | ST81162 |
| Object Details (DOV) | Use the new RHS tab to display cache bindings. | ST95211 |
| Additional attributes of databases, such as status, size, timestamp creation, now display. | ST95218 | |
| Object Editor (DOE) | The Server Options dialog no longer has a category drop-down list. All options display and can be easily filtered when you search for a specific option. | ST93582 |
| You can now add roles to logins. | ST95212 | |
| Object Explorer | A column heading displays when you sort a list of indexes in Sybase ASE. | ST93289 |
| Size is now one of the table list attributes. | ST95219 | |
| A new feature is the ability to update statistics. | ST95220 | |
| System databases now display in a separate folder. | ST95223 | |
| Sybase Anywhere and Sybase IQ now have grant privilege for "Edit permission." | ST92736 | |
| Creation dates now display for all objects in the object palette. | ST95209 | |
| Easily create and view aliases from Object Explorer | ST95206 | |
| Functionality for Indexes in Sybase IQ has been improved with an intuitive interface to create a text index and search an index. | ST95903 | |
| Schema Compare & Sync | Fixed an issue with running Schema Compare & Sync on two tables. | ST95600 |
| There have been various bug fixes and enhancements to Schema Compare & Sync to improve functionality. | ST99118 | |
| Sybase IQ | You can now use Data Compare in Sybase IQ. | ST95904 |
| Stored procedures can now be debugged in the new stored procedure debugger for IQ and SA. Right-click a stored procedure from the Object Explorer and select Debug to access this feature. | ST98075 | |
| Script Generation | Individual foreign key scripting is not supported. The foreign key portion of table scripts is achieved through the use of the ALTER TABLE syntax. | ST95213 |
| For object creation, such as procedures and views, a new "Print Statements" option has been added. | ST95222 | |
| "Create Like Login" functionality is improved and now includes roles and users. | ST95205 | |
| The following tabs have been added to display segment mapping: Script, Devices, Tables and Indexes. | ST95216 | |
| Fixed issue with having an arithmetic error when looking at the database script tab for databases with multiple large devices. | ST96108 | |
| When generating the script for a table, there is a new option that allows you to generate create default and sp_bindefault statements instead of always generating them inline. | ST94165 | |
| Procedure execution mode has been added to procedure script. | ST95203 | |
| Script Tab | You can now reserve options in the Script tab. | ST95203 |
| Script generation now includes grant information. | ST95204 | |
| Session Browser | Session Browser and Performance Monitor are now available in Sybase IQ. | ST98074 |
| SQL Editor | You can now send multiple scripts to a single editor. | ST93288 |
| User Interface | There is now a graphical display of device allocation. | ST96366 |
| Feature | Resolved Issue | Defect ID |
|---|---|---|
| Import Wizard | An exception no longer occurs when a user without select privilege imports data into a table. | ST92984 |
| Project Manager | An error message no longer displays when you drag and drop from the Project Manager to the editor. | ST93199 |
| Object Palette | Table information now displays for a table with both a default value and encryption key. | ST93196 |
| Create Function | The database context of the editor now changes if the database is changed. | ST93206 |
| Data Grid | You can now edit data in a table using a Sybase IQ connection. | ST93193 |
| Object Explorer | The create like dialog now checks for single quotes, double quotes and brackets and replaces them with single quotes. | ST93340 |
| Parameter names no longer change when evaluating a SQL statement in Sybase SQL Anywhere. | ST93584 | |
| Rules now display in all listing types. | ST93549 | |
| You no longer receive an error message create a foreign key in the Foreign Keys tab. | ST95730 | |
| Schema compare | Schema Compare no longer shows an exception when the maximum number of connections has been reached. | ST93478 |
| Sybase IQ | Create Like now produces the correct SQL. | ST93440 |
| Database Object Editor | When a column is renamed in the alter table dialog, SQL is generated to rename the column instead of dropping and re-adding it. | ST93619 |
| Database Object Viewer | An error no longer appears when you view users/groups in the Permissions tab. | ST93817 |
| User Interface | New | Create Foreign Key now works correctly. | ST94232 |
| Script Generation | The syntax for checking if an index exists has been corrected. | ST95207 |
| General | Updated functionality. | ST95200 |
| Updated functionality. | ST95199 |
| Feature | Resolved Issue | Defect ID |
|---|---|---|
| Options | Toad for Sybase now supports the use of the Merant ODBC driver syntax to connect to Sybase. | ST91665 |
| Object Editor | An exception no longer occurs when you view the device edit form after changing the name of the master device. | ST90387 |
| Connection Manager | You can now connect normally to Sybase IQ when the database name is numeric. | ST90491 |
| Object Details | All columns now display when you view details for lists. You no longer need select Refresh Item. | ST92079 |
| Explain Plan | Fixed issue of receiving an error when you click the Explain Plan icon multiple times in the Editor toolbar. | ST92481 |
| SQL Editor | Fixed issue with Formatter not formatting a long query. | ST81532 |
| Fixed issue with the DROP not indenting when you apply Formatter. | ST84776 | |
| Fixed issue with getting an error in Editor when editing SQL. | ST89577 |
| Feature | Known Issue | Defect ID |
|---|---|---|
| Query Builder |
In Sybase IQ and Sybase SQL Anywhere, queries with a varchar datatype that contain single quotation marks do not function correctly when generating the explain plan. Workaround: Replace single quotation marks with double single quotation marks when generating the explain plan. Note: This fix only affects the explain plan code for IQ and SQL Anywhere. |
ST92945 |
| Debugger | An ASE exception occurs when stepping into or over a function during procedure debugging. | ST94273 |
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/ One Click Export |
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 |
| ADO.Net Driver | Debugger does not allow you to step into or out of procedures. | N/A |
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
|
Platform |
1 GHz minimum |
|
Memory |
512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
|
|
Hard Disk Space |
53 MB to run Toad |
|
Operating System |
Windows Server 2003 Windows Server 2008 (32-bit or 64-bit) Windows Server 2008 R2 (64-bit) Windows XP Professional (32-bit or 64-bit) Windows Vista (32-bit or 64-bit) Windows 7 (32-bit or 64-bit) |
| .NET Framework |
Microsoft .NET Framework 3.5 (Service Pack 1) Note: The following conditions apply:
|
|
Additional Software |
Web Browser Microsoft Internet Explorer 6.0 or later |
|
Operating System |
Windows XP (32-bit with Service Pack 2 or later and 64-bit) Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later Windows Vista (32-bit or 64-bit) Windows Server 2008 (32-bit or 64-bit) Windows Server 2008 R2 (64-bit) Windows 7 (32-bit or 64-bit) |
|
Database Server |
Sybase ASE 12.5, 15.0.2, 15.0.3, 15.5, 15.7 Sybase IQ 15.0, 15.1, 15.2, 15.3, 15.4 Sybase SQL Anywhere 10, 11, 12 |
Review the following information about using Toad in virtual environments:
| Application Virtualization |
Limited testing has been performed for Citrix XenApp 5.0 support on Windows Server 2003. 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. |
| Desktop Virtualization (VDI) |
Toad has been tested with Quest vWorkspace 7.0 running on Windows XP Professional 32-bit (Service Pack 2). Toad has been tested with Quest vWorkspace 7.0 running Windows 7 Enterprise 32 bit. |
|
Note: Toad may work in virtualization environments other than the ones in which it was tested. |
|
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:
Adobe® Acrobat Reader 7.0
Refer to Toad for Sybase Installation Guide for installation instructions.
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.
|
|
|
|
|
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 Support Portal at www.quest.com/support.
From our Support Portal, 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: www.quest.com/support.
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.
© 2013 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, Spotlight,