Release Notes

Toad™ for MySQL 7.7

Release Notes

Friday, October 30, 2015

About 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 Features

New Features

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

Automation

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

• You can now use the asterisk (*) and question mark (?) wildcard characters, as well as variables, in a file name to help you select one or more files (in the same directory) to add as attachments. To use this method, do the following:
  1. After clicking the Add Attachments button in the Send Email activity, click the browse button in the File Collection Editor.
  2. Browse to and select one of the files to set the path and the base file name. Click Open in the browse window.

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

Query Development

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.

  

Database Management

Data Compare

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

• Because the Data Compare project is now in XML format (instead of a binary file format), the file is easier to read when opened and reviewed in a text editor.

Import and Export

Export Wizard

• When entering a query in the Export Wizard query editor, pressing the ENTER key now creates a new line instead of attempting to advance to the next page of the wizard.
• Code completion is now available in the Export Wizard query editor.

Connections

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.

  

General

Page Setup

• Margin settings in File | Page Setup are now retained between Toad sessions.

The Library

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.

• When you add a file to the Library, you can add tags and a topic to the file to make it easier to search for the file within the Library. You can also group and filter files by tags and topics in the Library.
• Each file is added to the Library, but remains in its original location. A reference to the file is added to the Library and includes the file name, file path, file type, date created, and date modified.

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

  

• You can run an Automation script from the Library. Right-click the script and select Execute.

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.

• After you integrate Toad for MySQL with your version control system, you can perform version control tasks directly from within Toad for MySQL, such as commit your changes or retrieve the latest file revision from the remote repository.
• Toad supports Apache Subversion™ for managing Toad files. Toad has been tested with Subversion 1.7.5 and 1.8.
• You can manage the following file types using version control within Toad for MySQL: Editor (.tef, .sql, .txt), Query Builder (.tsm), ER Diagram (.ter), and Automation (.tas).

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

  

• After configuring version control, to add a file, right-click the document tab and select File Version Control | Add file to working folder.

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

  

Idea Pond

• Idea  Pond is a site where you can submit your ideas to improve Toad and vote or comment on other people's ideas. Toad's development has always been driven by our customers, and now it is even easier for you to tell us what changes are most important. This site is free for all customers.
• Got a great idea for a new Toad for MySQL feature or enhancement? Share it with the Development Team and the Community by posting it on Idea Pond.
• Visit Toad for MySQL Idea Pond where you can submit your ideas. You can also read and vote on the enhancement ideas submitted by other users.

Resolved Issues

Resolved Issues and Enhancements

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

Known Issues

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