Toad® for MySQL

Beta Version 7.2

Beta Release Notes

January, 2014


Contents

Welcome to Toad

New in This Release

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Global Operations

Getting Started

For More Information


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.


New in This Release 7.0

Database Administration

Query Development

Data Management

Automation

Import/Export

Idea Pond

Database Administration

General

Toad now allows you to search through the script not only in the Editor window but also in SQL Script page of object's DOE (Database Object Editor) and Script tab in the object's DOV (Database Object Viewer). This feature can be handy when reviewing large automatically created DDL scripts. Press F3 or CTRL+F to invoke a search pane.

Object Explorer

Query Development

Editor

Script Results

Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.

Data Management

Data Grid, Result Sets

Toad allows to view multi-line text as one-line separated by spaces so that you can see all information contained in the grid right in front of you. Right-click a data grid and select Show | Multi-line text as one-line. When this option is cleared, to view multi-line text you have to hover a mouse over a data grid cell or expand it.

 

 

Multi-Line as One-line Example

Selected

Cleared

Data Compare

Automation

Schema Compare and Data Compare Activities

Variables

This release of Toad for MySQL includes many new enhancements to Automation variables. Automation variables are now more flexible and easier to use. Toad for MySQL has expanded the number of places you can use variables in an Automation script.

Loop Dataset Activity

Set Variable Value Activity

Loop Connections Activity

Copy File and Delete File Activities

Automation Guided Tour

General Automation Enhancements

This release also includes several general enhancements to Automation activities.

Important!

Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, a message informs you that the script will be upgraded so it will work in the current version of Toad.

Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\bak folder in the Application Data Directory under Help | About.

Compatibility

Validation Error Icon

If you choose to upgrade an Automation script created in a previous version of Toad for MySQL, after opening the script, look for the validation errors icon.

Expressions Used in Automation

Some expressions might break in this release of Toad for MySQL. For example, if you used a variable in an expression, you must now surround the variable name with the hash (#) symbol (#MyVariable#).

Import/Export

Resolved Issues and Enhancements

Toad for MySQL 7.0

This release focused on enhancements. See New in This Release 7.0 to view enhancements to this release.

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

Toad for MySQL 6.7

Feature

Known Issue

Defect ID

Data Grid In a table with a column that contains tinyint(1) data type, the number value now displays in the data grid when you connect without ODBC. ST103551
Automation

In the following environment, Microsoft .Net Framework 4 installed on Windows 7 or Windows Server 2008 R2, some users may experience that Toad unexpectedly closes while running certain Automation scripts. After the application closes, a "Toad has stopped working" message displays. You may also encounter this issue if you close Toad immediately after the successful execution of certain Automation scripts. Workaround: Install Microsoft Framework .Net 4.5.

Workaround:

Install Microsoft Framework .Net 4.5.

N/A

Toad for MySQL 6.3

Feature Resolved Issue Defect ID
Installation/ 
Upgrade
MySQL now creates server objects used for the debugging engine. ST90498
Automation Properties and script settings now display only when the activity or settings icon is selected in the design window, making it more difficult for the user to accidentally change script settings and activity properties. ST89010
You now have the option to choose whether or not to truncate the script’s log file each time the script runs. ST90268
In the Select to File activity, response time is greatly improved when user enters a SQL statement into the text box. ST91012
In the Delete File activity, when you click Add Files, the File Collection Editor correctly displays and allows you to select from the files that are created earlier in the script. ST91851
Information sharing between activities is improved. For example, if you delete an activity that creates a file, that file is also deleted from any later tasks in the script where it is used as an attachment or other input. ST88038
You can now change the order of the Find and Replace tasks in a Find and Replace activity. Also, a Cancel button has been added to the Find and Replace Editor.

ST79016

ST79095

You can now perform one Find and Replace task on multiple files at one time by using standard wildcard symbols (?) in the file name. ST81010
Right-click an activity in the script design window and select Enabled to easily enable/disable the activity. ST91388
A Cancel button has been added to the File Collection Editor so you can cancel out of the operation even after making some modifications. In addition, you can now select multiple files at one time using CTRL+click. ST90101
Data Compare You can now use the synchronization wizard in data compare. ST90950
Editor You can now import and export code snippets.

ST82391

ST91378

You now have the option to save snippets in the Shared Snippets folder. ST90014
In the Editor toolbar, all of the execute buttons are now consolidated under one button. This main button retains the function of the last action for the selected (active) Editor window. The other execute buttons are always available beneath the Execute SQL button via a drop-down list. ST91761
In the Pivot and Chart grid, the default format for numerical data is no longer currency; it is now the number format. ST59695
For all databases, including Oracle, the error log in the Editor and the Query Builder now provides the line and position for syntax errors. ST91218
When your Editor window includes multiple SQL statements, you now have the option to send only one statement to the Query Builder by highlighting that statement before selecting Send To Query Builder. ST80339
Export Wizard/One Click Export You can now export a list to SharePoint using the Export Wizard. ST91305
Import Wizard You can now import a list from SharePoint using the Import Wizard. ST91306
You now have the option to use your current regional settings when importing data. The data is parsed using the settings of the region that you have specified (on your PC). ST90721
Query Builder The elapsed time now displays in the lower right corner of the Query Builder window while a query is executing. ST92001
Now Toad remembers your last layout for Navigation Manager (pinned or unpinned) for saved Query Builder files and reverts to this layout when you open the file. ST91596
Checkbox selection is again available to add an object to a query. You can also right-click the column to add it to the output. ST91991
You can right-click a column name in the table diagram and select Delete from Output. ST91710
Project Manager When you right-click a file and select Browse, the file's location folder opens in a Windows Explorer window, instead of in a browser window within Toad. In addition, the file is already selected in the window for easy opening. ST74182
You can now sort the contents of a project folder or sub-folder. Right-click a project or folder and select Sort. The contents sorts alphabetically. ST78965
Saving a connection to the Project Manager by right-clicking a project or folder and selecting Add | Database Connection now works as expected. A list of connections displays. ST84461
Note: This list does not include every resolved issue for this release. To inquiry about an issue not listed here, please contact the Toad for MySQL Team at the Toad for MySQL community Web site.

Toad for MySQL 6.0.1

Feature Resolved Issue Defect ID
Installation/ 
Upgrade
Toad now supports installation on Windows Vista and 7. The UAC is no longer disabled when you install on Windows Vista and 7. ST68492
General Switching from the default to another skin in Tools | Options | Environment | Interface no longer results in an error ST72541
Query Builder The pivot grid now displays correctly when you execute a query and create a pivot grid in the Pivot & Chart tab, and then re-execute the query and attempt to create a pivot grid with the second result set ST71065
Object Explorer/ Database Explorer You can now filter databases and objects. ST46945
When altering a table, the Columns page now sets the Unsigned property for Unsigned columns. ST48653
BIGINT data types are now supported in the Data tab ST75090

Back to Top


Known Issues

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

Feature Known Issue Defect ID
Schema Compare The timestamp column does not show differences when tables are updated. ST95642
Data Compare Views do not display in the New Comparison Wizard. ST95575
Debugger When you debug a stored procedure, Toad inserts its own statement in the user's Declare Cursor in both Procedure and Function causing a SQL error. ST93716
Automation

There are some problems with Toad for MySQL running as administrator on Windows 7/Vista systems with UAC turned on and Outlook running.

Workaround:

Either run Toad not as administrator or turn UAC off or close Outlook while opening Automation and also every time you add Send Email activity in the designer.

ST80857

Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, a message informs you that the script will be upgraded so it will work in the current version of Toad.

Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\BAK folder in the Application Data Directory under Help | About.

ST79125
Data For some queries, attempting to right-click a row and select Row Count results in a message stating that the row count could not be determined N/A
Export Wizard/ One Click Export

(Windows 7 only) When exporting data to an Excel instance using the Export wizard, Toad stops responding.

Workaround: 
On Windows 7, use One Click Export to Excel Instance to export data instead.

ST67980
Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit N/A
Import Wizard Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error. N/A
Query Builder Currently, you cannot reverse engineer a query that contains a WHERE EXIST clause. ST75090
Version Control

If you migrate settings when upgrading Toad, you may have to reconfigure the repository setting in version control if a "Failed to open the settings for module VersionControl reverting to defaults" error displays.

Workaround:
To reconfigure the repository, select Tools | Options | Version Control | Defaults and select the previous repository in the Version control folder field. Your previous project settings are applied.

N/A
In previous releases, the method Toad used to generate the script was different than the current method. After upgrading Toad, a message may display stating that objects or files in version control are different than the local version. If your local version is current, you should check the objects and files into version control. N/A

Third Party Known Issues

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:

  1. Save the zip file to your computer.

  2. Right-click the saved zip file and select Properties

  3. Select the Unblock checkbox.

ST49799

Automation in MySQL 7.0 or later requires .NET Framework 4.5. If you are using .NET Framework 4.0 without .NET Framework 4.5 (such as in Windows XP), you may encounter the following:

  • After running a scheduled Automation script, Toad generates an error message even though the script executes successfully.

Workaround: Upgrade your Windows OS to Windows 7 and install .NET Framework 4.5.

N/A
Data

Currently, Korean characters are not supported.

ST41612
If the value of a TIME data type is greater than 24-hours, the value does not display correctly. N/A
Currently, geometry data types are not supported. ST70327
Import Wizard Importing large data sets from Excel (approximately 650,000 rows) is not recommended because of the amount of time it may take. This issue occurs because the Excel import component maintains the output in memory until the import completes. This can cause performance issues depending on the available system resources. CR219754

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:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en  

2007 PIAs:

http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en  

CR219754


System Requirements

Client Requirements

Toad for MySQL, ensure your client system 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:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

1.33 GB to install

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server 2003 (32-bit or 64-bit)

Windows XP Professional (32-bit or 64-bit)

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)

Windows 8 (32-bit or 64-bit)

Important: Toad uses the Microsoft Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista and Windows Server 2008. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.

.NET Framework

The .NET Framework is required. The version is dependent on the operating system.

.NET 4.5 Windows Vista SP2, Windows 7, Windows 8, Windows Server 2008 SP2, Windows Server 2008 R2, Windows Server 2012
.NET 4.0 Windows XP, Windows Vista (SP1 or earlier), Windows Server 2003, Windows Server 2008 (SP1 or earlier)

Additional Requirements

Web Browser

Microsoft Internet Explorer 6.0 or later

PDF Viewer

Adobe® Acrobat® Reader 7.0 or later (for viewing the Toad for MySQL Installation Guide)

Virtualization Support

Application Virtualization

Limited testing has been performed for Citrix XenApp 5.0 support on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

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.

User Privilege Requirements

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


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 MySQL 7.0
  2. Product Documentation, including:

Installation Instructions

See "Toad for MySQL Installation Guide" for more information.


For More Information

Contact Quest Software

Email

info@quest.com

Mail

Quest Software, Inc.

World Headquarters

5 Polaris Way

Aliso Viejo, CA 92656 

USA

Web site

www.quest.com

See our web site for regional and international office information.

Back to Top

Toad Community

Get the latest product information, find helpful resources, and join a discussion with the Toad for MySQL Quest team and other community members. Join the Toad community today.

Back to Top


 

© 2014 Dell 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 Dell Software Inc.

The information in this document is provided in connection with Dell Software 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 Dell Software products. EXCEPT AS SET FORTH IN DELL SOFTWARE’S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, DELL SOFTWARE 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 DELL 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 DELL SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Dell Software 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. Dell Software 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:

Dell Software Inc.
Attn: LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

Refer to our web site (www.software.dell.com) for regional and international office information.

Patents

Protected by U.S. Patents #6,901,582 and 7,784,027. Additional patents pending.

Trademarks

Dell, the Dell logo, Benchmark Factory, LiteSpeed, Simplicity at Work, and TOAD WORLD are trademarks of Dell Inc. and/or its affiliates. Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Dell disclaims any proprietary interest in the marks and names of others.