Friday, October 30, 2015
About Toad for MySQL
New in This Release
Resolved Issues and Enhancements
Third Party Known Issues
For More Information
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.
Send Email Activity - Authentication in Non-SSL Connection
You can now use the Email Server Settings dialog in the Send Email activity to authenticate your connection even if you are not using an SSL/TLS connection. Previously, the User name and Password fields in this dialog were enabled only when the Use Secure SSL/TLS connection option was selected.
Now, you can enter a user name and password to authenticate with non-SSL connection.
Send Email Activity - Use Wildcard Characters to Select Attachments
Then, in the File Collection Editor, modify the selected file name (in the right pane) by using wildcard characters and/or variables. Toad will use this modified name to select attachments when the script runs.
Data Compare Activity
The Data Compare activity now includes a variable that returns True or False based on the outcome of the comparison. This allows you to easily determine whether or not the comparison was equal without reviewing the generated report. In addition, you can use the variable to trigger other tasks later in the script, such as with an If Condition activity.
Run Program Activity
A return code (exit code) with a value of 16384 (4000 hex) or larger is no longer treated as an error by the Run activity.
Background: In the previous release, any non-zero return code (exit code) was treated as an error by the Run activity. So if you used any non-zero exit code returned by your program (and assigned to the Return Code Variable) to determine actions in a subsequent activity, your script would also generate an error. Also, this method required disabling the Stop on Error option for the activity or script.
Now, when a non-zero code is returned, you can use your program to generate a custom return code and specify a value of 16384 (4000 hex) or larger. This value will not generate a script error. In addition, if you use this method you can enable the Stop on Error option for the activity or script, if necessary.
Populate Where Clause with Values from File
If you are using IN or NOT IN in a WHERE clause, you can now load multiple values from a .txt, Excel, or .csv file.
In the Query Builder, use the Where Condition editor to select the file containing values.
After the file is uploaded, the values are automatically added to the Where clause. Click the down arrow to display the loaded values or to deselect some values.
In the SQL Editor, select Get values from file in the code completion list. Then browse to and select the file containing values.
Display Multiple Results in a Single Grid
When a query returns multiple results, you can now display all results in a single grid. When multiple results are displayed in a single tab, select All results to display all result sets in a single grid, or use CRTL+Click to display only the selected sets.
To enable/disable this feature, go to Tools | Options | Database | Script Result. Select All in one tab and then select Enable all results view.
Background Processes Icon
The animated background processes icon has been enhanced to provide a clearer indication that a window is associated with a currently running process.
For each Query Builder or Editor document with an active background process, this animated icon displays in the window's tab. This allows you to quickly see which windows have executing statements.
The Data Compare project file has a new XML format. The file extension (.dcp) remains the same. New Data Compare projects you create are saved using this new XML format. Data Compare files created in previous versions of Toad are supported. However, if you open a Data Compare file created in a previous version of Toad, the file is converted to the new XML format.
Important: Beginning with this release, if you create or modify a Data Compare project in an Automation script that runs against a password-protected database, you must save the password in the Toad connection. To save the password, right-click the connection in the Connection/Navigation Manager and select Properties. Enter the password and select the Save Password option.
Passive Mode is Available for FTP Connections
You can now use Passive mode for an FTP connection. When defining a new FTP connection or modifying an existing one, select Passive from the Mode drop-down list in the Connection Properties dialog.
This release includes a new interface for organizing and accessing your Toad files—the Library.
Adding files to the Library is easy. Open the Library (Tools | Library). Click Add to Library and then browse to and select one or more files. You can also drag files or a directory to the Library window to add files.
As the number of files in your Library grows, use filter, group, and search features to easily find the files you need.
If you select Automatically add files to Library on open in Tools | Options | Environment | General, you can add tags and a topic in the Save As dialog when you save any file in Toad.
Version Control for Files
This release has re-implemented version control for Toad files. Toad can integrate with your existing version control system allowing you to manage multiple versions of Toad files.
To get started with version control in Toad, run the Version Control Wizard. To open the wizard, right-click the document tab of a supported document type and select File Version Control | Version Control Wizard.
The Repository Browser (Tools | Repository Browser) allows you to view all files in the repository. From the Repository Browser, you can open files, commit changes, retrieve the latest revision of a file, and check the status of one or more files.
The following is a list of issues addressed and enhancements implemented in this
Resolved Issue or Enhancement
|Automation||Send Email activity: You can now use the Email Server Settings dialog to authenticate (submit user name and password) even when you are not using an SSL/TLS connection.||QAT-3730, QAT-5508|
|Automation||In the Select to File activity, when attempting to export to a named sheet and adding a suffix to the file name, the file was overwritten. This issue is resolved.||QAT-5683|
|Automation||If the Execute Script activity links to a .sql file, the file path no longer unexpectedly displays in the activity's editor pane. This fix applies to new Automation scripts.||QAT-6021|
|Automation||Run Program Activity now works as expected when Continue on Error option is specified.||QAT-6400|
|Automation||When a variable value is drawn from database data which includes the backslash (\) character, you can now explicitly escape each backslash.||QAT-5746|
|Automation||If you attempt to create a custom activity name that includes spaces, Toad now prompts you and conveniently suggests a similar name without spaces. Spaces are not allowed in an activity name in a script.||QAT-3581|
|Data Compare||You can export comparison results to an Excel .xlsx format. This is useful for a comparison that contains a very large number of differences.||QAT-743|
|Database Diagram||After opening an existing Database Diagram file, you no longer encounter an error when attempting to refresh the diagram.||QAT-5921|
|Database Explorer||If the Database Explorer (Viewer) window is not the currently-active window, it no longer refreshes each time you select a different object or connection in the Object Explorer.||QAT-3638|
|Export Wizard||When exporting multiple tables as SQL Script, you can now select a database in Script Options, as expected.||QAT-5576|
|Export Wizard||When entering a query in the Export Wizard query editor, the ENTER key now creates a new line instead of attempting to advance to the next page of the wizard.||QAT-2246|
|Export Wizard||When attempting to export to certain macro-enabled Excel files, if Toad fails to load the macro, you are now allowed to either skip the macro and continue with the export process or cancel the export process.||QAT-5925|
|Export Wizard||An issue that caused a "This property is not supported for the current chart type" error when exporting to Excel is resolved.||QAT-5328|
|Export Wizard||An issue that caused the file to become corrupted and unusable after exporting to a macro-enabled Excel file with pivot tables and conditional formatting is now resolved.||QAT-6494|
|Export Wizard||When you select to append rows and include headers, headers are only included if no rows currently exist in export worksheet.||QAT-4224|
|FTP||You can now specify Passive mode for an FTP connection.||ST85851, QAT-4972|
|General||Enhancement: Margin settings in "File | Page Setup" are now retained between Toad sessions.||QAT-6051|
|Installation||During installation, if .NET Framework 4.5 is not installed, Toad once again correctly warns the user and then stops the installation process.||QAT-5911|
|Job Manager||Enhancement: You no longer need to open a connection before you can open the Job Manager.||QAT-6023|
|Object Explorer||Creating a Schema filter using "Equals" and Case Sensitive = "False" with a value containing upper case characters now works as expected.||QAT-6333|
|Options||In Options | Environment | Keyboard, you can now view a report of keyboard shortcuts even if Internet access is blocked for Toad.||QAT-5917|
|Options||In Options | Editor | General, if you add a custom color, it is now retained in the color palette after closing the Options dialog. To create a custom color, right-click in an empty custom color square in the color palette.||QAT-4035|
|Print Settings||Margin settings (File | Page Set-up) are now retained between Toad sessions.||QAT-6051|
|Query Builder||If using IN or NOT IN in a Where clause, you can now load multiple values from a file in the Where Condition editor.||QAT-5630|
|Query Builder||When you create a calculated column, the name you define in the Calculated Fields dialog now displays as the column's name in the Criteria pane (lower pane) of the Diagram tab.||QAT-5482|
|Query Builder||Enhancement: When you rename a subquery, the new name now displays in the Queries navigation pane, as well as the Criteria pane and the table diagram.||QAT-1035|
|Query Builder||Attempting to reverse engineer a query that uses INTERVAL in a DATE_FORMAT() function now works as expected. The INTERVAL keyword is no longer removed.||QAT-6262|
|Query Builder||In the Calculated Fields dialog, the names in the list of current calculated columns now display correctly.||QAT-6249|
|SQL Editor||If using IN or NOT IN in a Where clause, you can now load multiple values from a file by selecting this option in the code completion list.||QAT-5832|
|SQL Editor||Enhancement: The Messages tab now includes an action (right-click and select Filter Output) to allow you to filter out message content, for example the duration or the timestamp.||QAT-4305|
|SQL Editor||Enhancement: Added a new option (Tools | Options | Editor) to allow user to disable/enable auto refresh of the Object Explorer after the execution of a Create or Drop DDL statement.||QAT-6633|
|Toad Data Report||Improved support for extended DPI settings in Data Report Wizard.||QAT-4644|
|Toad Views||When creating multiple views in the Toad Views window, views are named correctly.||QAT-6110|
|User Interface||In Korean Windows 7 environment, text and other user interface elements are no longer truncated and now display as expected.||QAT-4422|
|User Interface||Object Explorer details pane (lower pane) now retains height setting between Toad sessions.||QAT-5554, QAT-5578|
|User Interface||In the Metropolis Dark theme, disabled menu options are now visible, but "grayed-out" as expected.||QAT-6352|
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.||
|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|
There are some problems with Toad for MySQL running as administrator on Windows 7/Vista systems with UAC turned on and Outlook running.
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.
|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|
A UAC setting at the highest level might interfere with the ability to drag a file to the Library window (from Windows Explorer) to add it to the Library.
Workaround: Set UAC to the default level to enable adding a file by dragging it to the Library window.
The following is a list of third party issues known to exist at the time of this release.
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:
Workaround: Upgrade your Windows OS to Windows 7 and install .NET Framework 4.5.
Currently, Korean characters are not supported.
|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.||ST219754|
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:
|Export Wizard||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|
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
512 MB of RAM minimum, 1 GB recommended
Note: The memory required may vary based on the following:
Hard Disk Space
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.
The Microsoft® .NET Framework is required. The version is dependent on the operating system.
Microsoft® Internet Explorer® 6.0 or later
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
MySQL 4.1, 5.0, 5.1, 5.5, 5.6
|Cloud Database Service||Toad for MySQL can manage Amazon RDS and any other cloud or service offering compatible with MySQL, including Amazon Aurora.|
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.
Only Windows Administrators and Power Users can install Toad.
If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User, Vista standard user—on the computer.
If a Power User installs Toad, a Restricted User cannot do the following:
The following describes the requirements and restrictions for users who launch and run Toad:
This product does not require licensing.
The Toad™ for MySQL release package contains the following products:
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
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.
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.
To view Release Notes for previous versions, visit http://documents.software.dell.com/toad-for-mysql/.
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.
For sales or other inquiries, visit http://software.dell.com/company/contact-us.aspx or call 1-949-754-8000.
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
© 2015 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:
Attn: LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656
Refer to our web site (software.dell.com) for regional and international office information.
Dell, the Dell logo, Quest, SQL Navigator, vWorkspace, and Toad are trademarks of Dell Inc. and/or its affiliates. Microsoft, Windows, Windows Server, Windows Vista, Visual Studio, SharePoint, Access and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Oracle is a trademark or registered trademark of Oracle and/or its affiliates in the United States and other countries. Citrix® and XenApp™ are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries.