In full screen mode, you can switch back to your previous screen size and displayed toolbars by clicking Full Screen beside the menu.
Version 4.6.0
Release Notes
February 09, 2010
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.
Review the following sections for updates in this release and new features:
In full screen mode, you can switch back to your
previous screen size and displayed toolbars by clicking
Full Screen beside the menu.
When opening a previously saved ER Diagram file, you can right-click the Diagram pane and select Refresh to get the latest objects from the database, including added/removed columns and data type updates.
You can also select the Mark diagram objects that differ from the database objects when loading a file checkbox in Tools | Options | Database | Digramming to add an * to the right of a object name if the object has been updated since you saved the file.
You can now toggle the Pivot & Chart tab to display the pivot grid and chart vertically (default) or horizontally from the right-click context menu.
The horizontal display looks as follows.
When opening a
previously saved Query Builder file, you can right-click
the Diagram pane and select Refresh to get the
latest objects from the database, including added or
removed columns and data type updates.
If you select the Mark diagram objects that differ
from the database objects when loading a file
checkbox in Tools | Options | Database | Digramming,
an * in the title of the object indicates that the saved
version differs from the database version.
When using an IN or
NOT IN operator on a DateTime column in a Where
condition, you can now select multiple entries or all
entries.
Support for exporting directly to Excel 2007 and Excel 2010.
You can now execute an import template against a different connection than the one saved with it. For example, this allows you to use the same import template against your test, development, and production databases. To execute the template against a different connection, make sure you are connected to, and the new database has focus in the Navigation Manager when you execute the template.
If you right-click data and select Send To | Pivot Grid, a wizard bar has now been added so you can add the pivot grid to a project, set up the grid, or export it.
Note: If you encrypt the zip file, you must
have a zip utility that can support 128-bit or 256-bit unencryption.
You can now associate a
default local and remote directory that opens when you
connect a session from the Advanced tab.
Toad now remembers the last connected local and remote directories for an FTP session.
You can use a new browse
button to quickly locate files in your local directory.
You can now drag-and-drop files between local and remote directories.
You can now open a new project or save a project using buttons on the Project Manager toolbar.
The following is a list of issues addressed and enhancements implemented in this release of the Toad for MySQL.
|
Feature |
Resolved Issue |
Defect |
|
Import Wizard |
You can now import Excel 2007 files. |
ST42416 |
|
Object Explorer/ Database Explorer |
If you execute a script in the editor with autocommit disabled, and then hover over a node in the Object Explorer, Toad no longer appears to hang. |
ST55294 |
|
Query Builder |
When reverse engineering a query from the Query tab or the Editor, the Diagram tab now supports SELECT statements where the columns are qualified with the database name. |
ST49731 |
|
Version Control |
On Subversion, adding a large number of objects can result in decreased performance. |
ST50279 |
The following is a list of issues known to exist at the time of the Toad for MySQL release.
| Feature | Known Issue | Defect |
|---|---|---|
| Startup |
(Windows Vista on Toad client only) If you initially start Toad when logged in as a standard user and enter a license key, the license key should be saved to: C:\Program Files\Quest Software\Toad for MySQL 4.6 However, a standard user does not have write privileges in Vista to C:\Program Files so the key is saved to the following directory instead: C:\Users\username\AppData\Local\VirtualStore\Program Files\Quest Software\Toad for MySQL 4.6 If you later start Toad as an administrator, you are prompted to enter the key again because it is not in the C:\Program Files directory. |
N/A |
| Debugger | If you use a GET_LOCK command in a script you are debugging, you cannot debug the methods. | N/A |
| Editor | When using the View Object at Cursor (SHIFT+F4) feature, triggers are not found. | ST41627 |
|
Attempting to execute a "show innodb status" statement results in a "Net packets out of order" error message. |
ST41861 | |
| Export Wizard/ One Click Export | Blob and Binary data types cannot be exported in this release. |
ST41665 |
| Object Explorer/ Database Explorer | ||
|
Currently, you cannot filter databases or objects. |
ST46945 | |
|
When altering a table:
|
ST48653 ST43282 |
|
| Currently, BIGINT data types are not supported in the Data tab. | ST46945 | |
| 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. |
ST63004 |
| 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 | |
| The Update Database function for version control often requires that objects be dropped and recreated. If tables are referenced by Foreign Key constraints, the following error occurs when executing the script "Could not drop object N because it is referenced by a FOREIGN KEY constraint." |
ST42093 |
The following is a list of third party issues known to exist at the time of Toad for MySQL release.
| Feature | Known Issue | Defect |
|---|---|---|
| Data | Currently, Korean characters are not supported. |
ST41612 |
| Currently, 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 | |
| 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 |
Ensure that the client computer meets the following minimum requirements:
|
Platform |
1 GHz |
|
Hard Disk Space |
|
|
Memory |
512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
|
|
Operating System |
Windows Server 2003 (32-bit or 64-bit) Windows XP Professional (32-bit or 64-bit) Windows Vista Windows Server 2008 Windows 7
|
|
Additional Requirements |
.NET Framework Microsoft .NET Framework 3.5 (Service Pack 1) Notes:
Web Browser Microsoft Internet Explorer 6.0 or later
PDF Viewer |
Ensure that the server meets the following minimum requirements:
|
Operating System |
|
|
Database |
|
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.
The following user privileges are required for installing and running Toad for MySQL:
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.
From the Windows Start menu, select Settings | Control Panel.
- Double-click Administrative Tools.
- Double-click Microsoft .NET Framework 2.0 Configuration.
- 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.
- Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.
- Browse to the location of Toad.exe in the File field.
- Click Next to view permissions for Toad.exe.
- Set the permission to Unrestricted.
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 Toad for MySQL release package contains the following products:
| info@quest.com | |
| Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA | |
| Web |
Refer to 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 SupportLink, our self-service portal. Visit SupportLink at http://support.quest.com.
From SupportLink, 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: http://support.quest.com.
© 2010 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
Web site: www.quest.com Email: legal@quest.com |
Refer to our web site for regional and international office information.
Quest, Quest Software, the Quest Software logo, AccessManager, ActiveRoles, Aelita, Akonix, AppAssure, Benchmark Factory, Big Brother, BusinessInsight, ChangeAuditor, ChangeManager, DeployDirector, DirectoryAnalyzer, DirectoryTroubleshooter, DS Analyzer, DS Expert, ERDisk, Foglight, GPOADmin, Imceda, IntelliProfile, InTrust, Invirtus, iToken, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, LogADmin, MessageStats, Monosphere, NBSpool, NetBase, NetControl, Npulse, NetPro, PassGo, PerformaSure, Quest Central, Quest vToolkit, Quest vWorkSpace, ReportADmin, RestoreADmin, SelfServiceADmin, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Storage Horizon, Tag and Follow, Toad, T.O.A.D., Toad World, vAutomator, vControl, vConverter, vFoglight, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vSpotlight, vStream, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vBackup, Vizioncore vEssentials, Vizioncore vMigrator, Vizioncore vReplicator, Vizioncore vTraffic, Vizioncore vWorkflow, WebDefender, Webthority, 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.