Toad™ for MySQL Beta

Version 7.3 Beta

Beta Release Notes

Wednesday, August 27, 2014


Contents

Welcome to Toad for MySQL

New in This Release

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Product Licensing

Global Operations

Getting Started

For More Information


Welcome to Toad for MySQL

With Toad™ for MySQL, 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™ for MySQL 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

This beta release of Toad for MySQL includes the following new features and enhancements.

New Look

Database Administration

Query Development

Automation

Idea Pond

New Look

You will notice that this release of Toad for MySQL has a fresh new look. Several elements in the user interface have changed, including:

Toad Data Point has a new look. This release includes a sleek new design for the main toolbar, as well as a few user interface enhancements designed to simplify your Toad workflow.

Database Administration

Object Explorer

Filtering database objects has several new enhancements.

Connection/Navigation Manager

Query Development

New Commenting Feature in the Query Builder

Other Features

Automation

Idea Pond

Back to Top


Resolved Issues and Enhancements

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

Resolved Issues and Enhancements in 7.3

Feature

Resolved Issue or Enhancement

Defect ID

SQL Recall If you select a SQL statement in the Executed tab of the SQL Recall pane, the right-click menu item, Moved to named, is now enabled as expected. TMY-19
SQL Editor Tables that include a TIME data type column are now handled correctly (Toad Editor file). TMY-22

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
Installation For some languages (languages using double-byte character encoding) specified using the Current language for non-unicode programs option in the Windows Region and Language dialog, the trademark symbols do not display correctly in the installer.

TDB-645

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
Back to Top

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

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
Connections

In Toad for MySQL 7.2 or later, when connecting to MySQL using a connection created in Toad for MySQL 7.0 or earlier, some users may encounter the following error:

"Authentication with old password no longer supported, use 4.1 style passwords."

This is an error message from MySQL database and indicates that the connection password was created in a pre-MySQL 4.1 database.

Workaround: Connect to the MySQL database using Toad for MySQL 7.0 and run the following script. Replace the YOURDATABASEPASSWORD string with the actual password.

SET SESSION old_passwords=0;

SET PASSWORD=PASSWORD('YOURDATABASEPASSWORD');

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

Before installing Toad, ensure that 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 for MySQL
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

800 MB to install Toad for MySQL

Operating System

Windows Server® 2008 R2 (64-bit)

Windows® 7 (32-bit or 64-bit)

Windows® 8 (32-bit and 64-bit)

Windows® 8.1 (32-bit and 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, Windows Server 2008 and Windows 7. 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 Microsoft® .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 or earlier), Windows Server 2008 R2, Windows Server 2012

.NET 4.0

Windows XP, Windows Vista (SP1 or earlier), Windows Server 2003

Notes:

  • This information is provided to aid installation. Toad for MySQL is not tested on Windows XP. Windows Vista (SP1 or earlier), and Windows Server 2003.
  • The .NET Framework 4 Client Profile is not supported.

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 6.0 or later

Server Requirements

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

Database Server

MySQL 4.1, 5.0, 5.1, 5.5, 5.6

Clustrix 5.2

Cloud Database Service Toad for MySQL can manage Amazon RDS and any other cloud or service offering compatible with MySQL.

Virtualization Support

Application Virtualization

Limited testing has been performed for Citrix® XenApp™ 5.0 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.


Product Licensing

This product does not require licensing.


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™ for MySQL release package contains the following products:

  1. Toad for MySQL 7.3
  2. Product Documentation, including:

Installation Instructions

For installation instructions, see the "Toad™ for MySQL Installation Guide" found on the Community site, http://www.toadworld.com/products/toad-for-mysql/w/wiki/297.product-documentation.aspx


For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad for MySQL team and other community members. Join the Toad for MySQL Community at http://www.toadworld.com/products/toad-for-mysql/default.aspx.

Contact Dell

Dell listens to customers and delivers worldwide innovative technology, business solutions and services they trust and value. For more information, visit www.software.dell.com.

Technical Support:
Online support

Product Questions and Sales:
(800) 306-9329

Email:
info@software.dell.com

Technical Support Resources

Please be advised before installing: Toad for MySQL is an official Dell Software Inc. Freeware Product. This license does not entitle Licensee to receive technical support from Dell .

Get the latest product information and find helpful resources at the Toad for MySQL Community at http://toadformysql.com/index.jspa.

For the Beta version of Toad for MySQL, technical support is provided through the Toad for MySQL Beta community. Find Beta program information, Beta downloads, and the Beta Forum at: http://www.toadworld.com/products/toad-for-mysql/toad_for_mysql_beta_program/f/90.aspx

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

The information in this document is provided in connection with Dell 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 products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, DELL 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 HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Dell 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 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 Inc.
Attn: LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

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

Trademarks

Dell, the Dell logo, Quest, SQL Navigator, vWorkspace, and Toad 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.