Toad^® for MySQL

Version 3.1.1 (Click here for previous versions)

Release Notes

February 2008

Contents

Welcome to Toad for MySQL

Toad for MySQL is a database development and administration solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to MySQL expertise.

Developers and administrators have access to a community of users, peers, and experts to help solve development and administration issues and assist in developing applications and feedback for improving Quests products.

All of this comes with the backing of Quest Software, a healthy and growing corporate entity that can provide the necessary training, support, and superior customer service demanded by IT management.
 

Back to Top

New in This Release

Review the following updates for this release.

Updates to Toad for MySQL 3.1

General

• Performance Improvements―We are excited to announce major memory improvements for queries that return large results in the Editor and the Database Browser Data tab! The memory only increases by a couple of megabytes initially regardless of the size of the result set. Subsequent scrolling of the result set only reads into memory what is needed to display.

• Configuration—You now set the windows that automatically open when connecting to Toad from the Configuration wizard.
  
  
   

Query Development

• Editor:
  • View scripts in a full size window―Use docking controls to auto-hide or group the Editor panel, Code Navigator, and result sets. To display the Editor and Results panels in a separate, full size window, drag-and-drop the Results tab into the Editor window.
    
    
    
    Press F6 to switch between the two panels.
    
    
     
  • Error line highlighting―Ability to highlight the line in the Editor that caused an execution error. To do this, double-click the error message in the Script Output tab.
  • Change case and add comments―You can now change the case of text or comment or uncomment a line by selecting Editor | Advanced or from the Editor's right-click menu.
    
    
• Query Builder:
  • From clause subquery support―You can now add a subquery to a From Clause using the Query Builder toolbar or the right-click menu. A Queries panel displays on the left side of the window with the From Clause subquery. You can add tables and views and create joins the same way you normally use the Query Builder.
    
    After creating the subquery, click the parent query in the Queries panel to return to the original query. A From Clause Subquery table now displays in the Diagram panel with all the columns in the subquery. Use this new table as you would any other database object.
     

    

  • Date ranges―When you add a Where condition for a column that uses a DateTime data type, a new Date Range tab displays in the Where Condition window. The Date Range tab allows you to select a plain text tag such as, “Today,” “Last week,” “Last 30 days,” and “Current year.” The tag you select is added to the Where condition of your query and when executed, is substituted with a BETWEEN command using the appropriate date range. Date Range tags can also be used in the Editor so you can create queries manually.
    
    Date Range tags are also useful when executing SQL statements from Automation. You no longer have to edit regularly executed queries to change a date range when you need to retrieve data every month for the previous month. 
    
    
     

Database Administration

• Generate SQL drop script―You can now select Drop Script from the Generate SQL right-click menu in the Database Browser or Object Palette.

• Generate SQL retains Formatter settings―When using the right-click menu to generate SQL in the Database Browser or Object Palette, the settings specified in the Formatter Options pages are now retained.

• Data Compare―Provides the ability to:
  • Compare tables and views that have different owners, different names, or different column names.
  • Compare tables that do not have primary keys.
  • Compare specific columns of a table.
  • Change Data Compare project parameters through the Change Data wizard.
  • Connections listed in Data Compare are better integrated with environment in that it now displays connections based on the connections in the Connection Manager.

Data Management

• Grid customization―You can now customize the grid style when a skin is applied to Toad. You can modify this setting in the Configuration wizard (Tools | Configuration Wizard) or in Interface Options (Tools | Options | Environment | Interface).
  
  

• Read-only data―You can now set an option to make all data grids read-only by default.

• Search data―Ability to search data grids for word or phrase matches by pressing CTRL+F. Clicking Mark All in the Find window highlights all cells in the grid that match the find criteria.

Version Control

• Added support for the following additional version control providers:

  • Subversion

  • CVS
     

Back to Top
 

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of the Toad for MySQL.
 

Resolved Issues and Enhancements in 3.1.1

Resolved Issues and Enhancements in 3.1.0

Back to Top

Known Issues

The following is a list of issues known to exist at the time of the Toad for MySQL release.

Back to Top

Third Party Known Issues

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

Back to Top

Upgrade and Compatibility

For information about upgrading refer to the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for MySQL Freeware  3.1 | Documentation.
 

Back to Top

System Requirements

Client Requirements

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

Server Requirements

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

User Privilege Requirements

The following user privileges are required for installing and running Toad for MySQL:

• Only Power users and Administrators can install Toad.
• If a Power user installs Toad, a Restricted user can run the application but cannot
  see the Toad shortcut icon on the desktop or the Toad menu option in the Windows Start menu. As a workaround, Restricted users can create a shortcut to the application and place it on their desktop from the install directory.
• If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and the Toad menu option in the Windows Start menu with any user on the computer.
• In order to run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

1. From the Windows Start menu, select Settings | Control Panel.

2. Double-click Administrative Tools.
3. Double-click Microsoft .NET Framework 2.0 Configuration.
4. Click + to expand My Computer, and then select the Runtime Security Policy node. A list of tasks for the node display in the right panel.
5. Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.
6. Browse to the location of Toad.exe in the File field.
7. Click Next to view permissions for Toad.exe.
8. Set the permission to Unrestricted.

• In order to set or modify Toad Security settings, users must have privileges to create the QuestSoftware.ToadSecurity table if it does not exist. If the table does exist, users must have privileges to insert, update, and delete the QuestSoftware.ToadSecurity table.
   

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. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America,
Western Europe and Latin America, Far-East Asia, Japan.

The following limitation has been identified:

• The Knowledge Xpert feature is available with English language content only.

Back to Top

Getting Started

Contents of the Release Package

The Toad for MySQL release package contains the following products:

• Toad for MySQL  3.1.1
• Product Documentation, including:
  • Getting Started Guide
  • Online Help
  • Release Notes

Installation Instructions

For important installation information, refer to the Getting Started Guide available
from the Windows Start menu under Program Files | Quest Software | Toad for MySQL Freeware  3.1 | Documentation.
 

Back to Top

For More Information

Contacting Quest Software:

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

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract. Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

• Quickly find thousands of solutions (Knowledgebase articles/documents).
• Download patches and upgrades.
• Seek help from a Support engineer.
• Log and update your case, and check its status.

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

Back to Top

This document 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.

© 2008 Quest Software, Inc. ALL RIGHTS RESERVED.

Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

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

Disclaimer

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.

Back to Top