Toad^® for MySQL

Version 4.5.0  

Release Notes

July 27, 2009

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, as well as 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.

Quest Software, Inc., a leading enterprise systems management vendor, delivers innovative products that help organizations get more performance and productivity from their applications, databases, Windows infrastructure and virtual environments.

Back to Top

New in This Release

Review the following sections for updates in this release and new features:

• Prerequisites/Installation
• General
• Automation
• Database Administration
• Data Management
• Query Development
• Project Management
• Version Control

Prerequisites/Installation

• Toad now requires .NET Framework 3.5 (Service Pack 1) or later. You can download the latest .NET Framework at: http://www.microsoft.com/Net/Download.aspx

• Because of the new .Net Framework 3.5 (Service Pack 1) requirement, Toad can no longer be installed on Windows 2000 systems. However, Toad can still connect and manage databases running on Windows 2000 systems.
• On Windows XP and Windows Server 2003 platforms, the default location for settings files has been changed to: C:\Documents and Settings\Username\Application Data\Quest Software\Toad for MySQL 4.5 to provide an easier installation for Citrix environments and for those customers with support for roaming profiles. On Windows Vista and Windows Server 2008 platforms, the default location for settings files has been changed to: C:\Users\Username\AppData\Roaming\Quest Software\ Toad for MySQL 4.5 to provide an easier installation for Citrix environments and for those customers with support for roaming profiles.

General

• Toad provides out-of-the-box support for the Maria storage engine and MariaDB.

• Document recovery now works with any ER Diagram or Query Builder files to avoid losing your work. When you restart Toad after an unexpected close, Toad checks the timestamp on the backup file against the original file, and opens the file that has the latest timestamp. The document recovery option is located in Tools | Options | Environment | General.

• Connection information for each Editor, Query Builder, or other document window is now available by selecting the Show connection info on document tabs checkbox under Tools | Options | Environment | General.

• You can close the current tab in a window or all other tabs except the current one from the right-click context menu available on each Editor tab.

• You can use the new File Transfer Protocol (FTP) utility to transfer scripts, reports, or other files to and from an FTP server. Toad supports unsecured (FTP) and secure (SFTP) file transfers. To open this utility, select View | FTP Connections from the menu.  

  Right-click one or more files in the local or remote directory to upload, download, delete, or rename the files.

  You can also add an FTP connection in the Project Manager or as an activity in an Automation script.

Automation

• Most activities now include support for variables. Variables allow you to change data in your script or use a dataset collected from an activity in the automation script. For example, you can use variables to perform the following tasks:  

• Send an email to a group of people where the list of recipients is automatically selected with a query
• Generate repetitive reports where only the product number, date, region, or any other single element changes
• Customize file names by including a variable in the file name or automatically including the date that the automation script ran

• Find content in a file and replace it with the value of a variable

See "Use Variables in Automation" in the Toad help for more information.

• Support for Find and Replace and FTP file activities.

• Support for new system activities, including running programs, setting variables, if conditions, while, and loop datasets. 

• The Select to File activity now supports Excel options. 
  

Database Administration

General

• The Create menu has been removed because it duplicated functionality in the File menu. To create objects from a menu, select File | New | ObjectType.

Object Explorer

• Code completion is now available when using object editors.
• When editing objects in the Alter window or sending ALTER statements to the Editor, Toad now uses data directly from the database instead of using the cache.

Master Detail Browser

• When sending tables or views to the Master Detail Browser, Toad now automatically selects all columns. 

Data Management

General

• Toad is now Federal Desktop Core Configuration (FDCC) Compliant; however changes to the architecture to ensure compliance will result in a loss of existing data filters when upgrading to this release.

• Hexadecimal values of up to 255 bytes for binary data now display in the grid.

• You can now create pivot grids and charts directly from the results by selecting the Pivot & Chart tab.

• You can now format XML data.

• You can add a total value to a column of data or can add a subtotal value to grouped data if the Summary Footer Panel is displayed (right-click the data and select Show | Summary Footer Panel). To add a total value, right-click the data and select one of the options.

  If you have grouped columns using the Grouping panel (right-click and select Show | Grouping Panel), you can add a subtotal value to grouped records. 

Export Wizard

• You can now export data to Microsoft Access files. 

• When exporting to an Excel Instance only, columns are automatically resized to the width of the data.

• You can now create a new table within a database when exporting data.

Data Compare 

• You can right-click tables or views in the Object Explorer and select Compare Data to compare data within the context of the current connection and database.

• When comparing data, you can now auto-map target columns for selected source tables.

• When selecting a record, Data Compare automatically displays a side-by-side comparison of the values of the source and target row in the Row Viewer tab.

• When synchronizing a script, Data Compare now opens a script in Toad using an existing connection.

Query Development

Query Builder

• You can now sort columns alphabetically in the Diagram pane by selecting an option from the Sort columns in diagram by name drop-down list in Tools | Options | Database | Query Builder.
  

• You can now create a view in the Query Builder. 

• When saving a Query Builder file, Toad prompts you to save query results with that file. 

• Toad now includes synonym support when reverse engineering a query.

• You can now add a UNION, UNION DISTINCT, or UNION ALL operator to queries.

• You can compare results from a Query Builder query to data from the Data tab or Editor results using the right-click menu. 

Editor

• Toad now includes four pre-defined SQL Formats. You can select a pre-defined format or create your own custom formats from Tools | Options | Editor | Formatter.

• You can share Formatter settings for your team in a network share folder in Tools | Options | Editor | Formatter to ensure consistent coding standards. 

Group Execute

Group Execute now generates a single result set that contains the data from the query run on each connection. Toad automatically adds a Connection column to the results to show which connection the data came from.

SQL Recall

Toad supports deleting multiple statements in the SQL Recall window.

Debugger

• You can right-click a breakpoint in the Editor to edit its properties.

Project Management

Support for FTP connections, SQL Recall named SQL statements, and Database connections has been added to the Project Manager via the right-click menu. For Database connections, only databases that are currently connected can be added to the Project Manager. 

Version Control

• Support for Team Foundation Server (TFS) 2008.
• When configuring TFS, you can now specify a user name and password to log into TFS instead of using your Windows credentials.
• Improved handling of working directory initialization and handling of root folder and working directory.
• Support for multiple version control configurations that are active simultaneously.

Back to Top

Resolved Issues and Enhancements

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

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

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:

Citrix Requirements

Toad has been tested 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. See "Install Toad on Citrix Systems" in the Installation Guide for more information.  

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

  • Associate file extensions.

  • 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.
• 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.

Silent Install Requirements

Before you perform a silent installation, the following software must be installed on every system on which you are installing Toad:

• Microsoft .NET Framework 3.5 (Service Pack 1) or later

For information about installing Toad silently, see "Install Toad Silently" in the Installation Guide.

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.

Back to Top

Installation

The Toad for MySQL release package contains the following products:

• Toad for MySQL version 4.5.0
• Product Documentation, including:
  • Installation Guide
  • Online Help
  • Release Notes

Installation Instructions

For general installation information, see the Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for MySQL | Documentation.

Back to Top

For More Information

Contact Quest Software

See our web site for regional and international office information.

Back to Top

© 2009 Quest Software, Inc.

ALL RIGHTS RESERVED.

This document contains proprietary information protected by copyright. The software described in this document 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.

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

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

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, 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.

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