Version 6.7
Release Notes
August 30, 2013
Resolved Issues and Enhancements
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.
Now you can disallow Toad from connecting to the Internet if it is prohibited by your company's policy. Select Tools | Options | Environment | Security and check "Do not allow any Internet access from Toad" option.
Toad's interface became more customizable. Dual monitor support is now available. Enjoy! The document windows and panes can be used in the floating mode. For example, you can drag Editor as a separate document to another screen.
You can also arrange the layout so that the tab headers are located one under another. Select Tools | Options | Interface and check "Display document tab headers vertically" option.
You can now customize data filtering in the DOV (Database Object Viewer) to organize columns in ascending or descending order. Select the Filter icon in the Data tab of the DOV and navigate to the Order By page in the Filter Data pane. By default Ascending mode is on, to sort columns in descending order clear the checkbox next to selected columns.
When setting your Toad's look and feel in Options | Environment | Interface, you can see skin icons in the list.
When working with your scripts in the Editor, you can set connection category color as Editor's background color to ensure that you do not execute the script on the wrong server instance. This feature is handy if you have multiple Editor windows opened on several servers and you are constantly switching between them.
To set this option go to Tools | Options | Editor | General and select Apply connection color.
You can make words in the script uppercase or lowercase with a single click. Right-click a text and select UPPER CASE.
Toad allows to save messages to the file. Right-click a message in the Messages tab of the Results pane and select Save as.
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.
You can now use a colon (:) or a forward slash (/) in date/time formats used in Automation variables (except when the variable appears in a file name).
In the Import Wizard and Export Wizard activities, you can now use a variable in the Import/Export template file name.
You can use the following format to filter data from the dataset variable when referencing it:
<dataset variable name>.<filter parameter>
Example: Loop_data_1_SQL.region_id, where region_id is the column name
You can now use standard wildcard characters in the file name to help you select one or more files to copy or delete. Previously, you could use the only the asterisk (*) in the file name to select multiple files to copy or delete.
[pic of Delete File Collection editor]
You can now use a variable in the file name to select one or more files to copy or delete.
This release of Toad for MySQL includes a new Automation feature: the Automation Guided Tour, a helpful wizard that guides you through the process of creating a basic script.
After completing the wizard, your new script opens in an Automation window where you can further customize and add to the script, if required.
Open script and look for validation errors icon.
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.
This release also includes several general enhancements to Automation activities.
Schema Compare is now available as automation activity. Select it from the list of Database Activities.
You can also select Send to Automation when running Schema comparison wizard.
Data Compare activity was moved to the Database Activities.
When adding Data Compare activity to Automation, you can either select a comparison project prepared in advance (and alter it if necessary) or run new data comparison wizard.
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.
Data Compare wizard has been significantly improved and demonstrates fast performance.
Map Source Objects to Target page of the Comparison Wizards has been redesigned to make column mapping easier, more convenient and user-friendly. The objects are mapped automatically, even large databases are processed almost instantly. Columns Mapped column displays how many columns are mapped and mapping status, while the information pane at the bottom shows more detailed information.
Now mapping activities are organized in the toolbar and are also available from the context menu.
Select Map All or Map Selected in the toolbar to automatically map all or just selected source objects to the target objects by their name. When altering mappings you can completely drop them with Clear All or partially with Clear Selected and even Restore Mapping when changing comparison.
When altering your comparison (without changing source or target connection properties) schema extraction is no longer performed in Change Compare wizard, this saves much time especially when comparing large databases. To extract schema select Refresh in the Map Source Objects to Target page of the Comparison Wizard.
Now there is Save Comparison option in both New Comparison and Change Comparison wizards. It allows to save the comparison file without actually comparing data.
When refreshing comparison schema extraction is no longer performed. To refresh both schema and data select Refresh Schema and Data from the Refresh button pop-up in the Result pane toolbar.
The exclamation marks in Result (top) pane and Details (middle) pane indicate that the records contain duplicated values in comparison key and require changing of comparison key (previously such records were shown as conflicts). Hover the mouse over the exclamation mark to see the tooltip with detailed information.
When searching for the data in the Details pane you can select Search currently selected column only to search within the single column in addition to other options.
Data Compare improved working with large objects (for example tables where each record is very large, e.g. 10 or 20 MB). Entire data contained in the record is no longer loaded into RAM, that prevents interface freezing and running out of memory. Now only small piece of the data is loaded when displaying the record contents in the Details pane. Cell Viewer shows more data but also not all (approximately 4 KB), total and shown data size is also provided. To see the entire data select Show All considering that it will be loaded into RAM.
Note: If trying to view the image that is very large (more than 5 MB), only small part of it will be shown in text form.
The statements in the synchronization script are listed and processed in the following order: DELETE – UPDATE – INSERT. This order reduces the risk of constraint violations or prevents data conflicts.
Now you can import data into identity columns. When trying to import data in the table containing identity columns you will be prompted to turn on "Identity inserts" option in the Select Target page of the Data Import wizard to enable import.
Pasting and editing is allowed in the Text Diff Viewer. So now you can compare data and alter it right in one place.
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.
Toad for MySQL now contains a link to Idea Pond in the application. Use Idea Pond to submit ideas and suggestions for improving Toad for MySQL. Select Help | Idea Pond to submit your idea or click Toad World Idea Pond.
Toad for MySQL now supports Clustrix, which is compatible with the MySQL protocol.
The following is a list of issues addressed and enhancements implemented in Toad for MySQL.
|
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 |
| 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. | ||
| 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 |
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 ToadSS 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 |
| Execution Plan |
You cannot generate an estimated execution plan for a local temporary table because the execution plan uses a different connection to generate the plan and does not know about the temp table. Workaround: Use the actual execution plan button to generate execution plans for SQL that contains a temp table. |
N/A |
|
Limitations when exporting fractional seconds:
|
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:
|
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 |
| Installation |
When installing Toad into a Citrix virtualization environment, you might encounter the following Toad error message: “CryptographicException. The profile for the user is a temporary profile.” Then, when attempting to launch Toad after installation, you encounter a similar error message and Toad fails to open. Issue: This release of Toad for MySQL does not support temporary or mandatory profiles on Citrix. This issue involves Microsoft .Net Framework 4.0. See the following for more information: http://devnet.superoffice.com/Developer/Blog/verifying-licenses-on-temporary-profiles/. Workaround: In a Citrix deployment that requires the use of temporary or mandatory profiles, use Toad for MySQL 6.3(or earlier). |
QAT-580 |
| 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:
|
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 |
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:
|
ST49799 |
| 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 |
|
Excel |
If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662. |
ST42486 |
|
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: 2007 PIAs: |
CR219754 |
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:
|
|
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 |
Microsoft .NET Framework 4.0 Notes: The following conditions apply:
|
|
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) |
| Application Virtualization |
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. |
|
The following user privileges are required for installing and running Toad for MySQL.
To run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:
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.
The Toad release package contains the following products:
See "Toad for MySQL Installation Guide" for more information.
|
|
|
|
|
Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA |
|
Web site |
See our web site for regional and international office information.
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.
© 2013 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
email: legal@quest.com
Refer to our Web site (www.quest.com) for regional and international office information.
Patents
Toad for Cloud Databases contains patent pending technology.
Trademarks
Quest, Quest Software, the Quest Software logo, Benchmark Factory,