new features of toad for mysql 4.5

New in This Release

Review the following sections for updates in this release and new features:

Prerequisites/Installation

• Toad now requires .NET Framework 3.5 (Service Pack 1) or later. You can download the latest .NET Framework at:

• Because of the new .Net Framework 3.5 (Service Pack 1) requirement, Toad can no longer be installed on Windows 2000 systems. However, Toad can still connect and manage databases running on Windows 2000 systems.
• On Windows XP and Windows Server 2003 platforms, the default location for settings files has been changed to: C:\Documents and Settings\Username\Application Data\Quest Software\Toad for MySQL 4.5 to provide an easier installation for Citrix environments and for those customers with support for roaming profiles. On Windows Vista and Windows Server 2008 platforms, the default location for settings files has been changed to: C:\Users\Username\AppData\Roaming\Quest Software\ Toad for MySQL 4.5 to provide an easier installation for Citrix environments and for those customers with support for roaming profiles.

General

• Toad provides out-of-the-box support for the Maria storage engine and MariaDB.

• Document recovery now works with any ER Diagram or Query Builder files to avoid losing your work. When you restart Toad after an unexpected close, Toad checks the timestamp on the backup file against the original file, and opens the file that has the latest timestamp. The document recovery option is located in Tools | Options | Environment | General.

• Connection information for each Editor, Query Builder, or other document window is now available by selecting the Show connection info on document tabs checkbox under Tools | Options | Environment | General.

• You can close the current tab in a window or all other tabs except the current one from the right-click context menu available on each Editor tab.

• You can use the new File Transfer Protocol (FTP) utility to transfer scripts, reports, or other files to and from an FTP server. Toad supports unsecured (FTP) and secure (SFTP) file transfers. To open this utility, select View | FTP Connections from the menu.

  Right-click one or more files in the local or remote directory to upload, download, delete, or rename the files.

  You can also add an FTP connection in the Project Manager or as an activity in an Automation script.

Automation

• Most activities now include support for variables. Variables allow you to change data in your script or use a dataset collected from an activity in the automation script. For example, you can use variables to perform the following tasks:  

• Send an email to a group of people where the list of recipients is automatically selected with a query
• Generate repetitive reports where only the product number, date, region, or any other single element changes
• Customize file names by including a variable in the file name or automatically including the date that the automation script ran

• Find content in a file and replace it with the value of a variable

See "Use Variables in Automation" in the Toad help for more information.

• Support for Find and Replace and FTP file activities.

• Support for new system activities, including running programs, setting variables, if conditions, while, and loop datasets.

• The Select to File activity now supports Excel options.

  
  

Database Administration

General

• The Create menu has been removed because it duplicated functionality in the File menu. To create objects from a menu, select File | New | ObjectType.

Object Explorer

• Code completion is now available when using object editors.
• When editing objects in the Alter window or sending ALTER statements to the Editor, Toad now uses data directly from the database instead of using the cache.

Master Detail Browser

• When sending tables or views to the Master Detail Browser, Toad now automatically selects all columns.

Data Management

General

• Toad is now Federal Desktop Core Configuration (FDCC) Compliant; however changes to the architecture to ensure compliance will result in a loss of existing data filters when upgrading to this release.

• Hexadecimal values of up to 255 bytes for binary data now display in the grid.

• You can now create pivot grids and charts directly from the results by selecting the Pivot & Chart tab.

• You can now format XML data.

• You can add a total value to a column of data or can add a subtotal value to grouped data if the Summary Footer Panel is displayed (right-click the data and select Show | Summary Footer Panel). To add a total value, right-click the data and select one of the options.

  If you have grouped columns using the Grouping panel (right-click and select Show | Grouping Panel), you can add a subtotal value to grouped records.

Export Wizard

• You can now export data to Microsoft Access files.

• When exporting to an Excel Instance only, columns are automatically resized to the width of the data.

• You can now create a new table within a database when exporting data.

Data Compare 

• You can right-click tables or views in the Object Explorer and select Compare Data to compare data within the context of the current connection and database.

• When comparing data, you can now auto-map target columns for selected source tables.

• When selecting a record, Data Compare automatically displays a side-by-side comparison of the values of the source and target row in the Row Viewer tab.

• When synchronizing a script, Data Compare now opens a script in Toad using an existing connection.

Query Development

Query Builder

• You can now sort columns alphabetically in the Diagram pane by selecting an option from the Sort columns in diagram by name drop-down list in Tools | Options | Database | Query Builder.

  
  

• You can now create a view in the Query Builder.

• When saving a Query Builder file, Toad prompts you to save query results with that file.

• Toad now includes synonym support when reverse engineering a query.

• You can now add a UNION, UNION DISTINCT, or UNION ALL operator to queries.

• You can compare results from a Query Builder query to data from the Data tab or Editor results using the right-click menu.

Editor

• 
  

• Toad now includes four pre-defined SQL Formats. You can select a pre-defined format or create your own custom formats from Tools | Options | Editor | Formatter.

• You can share Formatter settings for your team in a network share folder in Tools | Options | Editor | Formatter to ensure consistent coding standards. 

Group Execute

Group Execute now generates a single result set that contains the data from the query run on each connection. Toad automatically adds a Connection column to the results to show which connection the data came from.

SQL Recall

Toad supports deleting multiple statements in the SQL Recall window.

Debugger

• You can right-click a breakpoint in the Editor to edit its properties.

Project Management

Support for FTP connections, SQL Recall named SQL statements, and Database connections has been added to the Project Manager via the right-click menu. For Database connections, only databases that are currently connected can be added to the Project Manager.

Version Control

• Support for Team Foundation Server (TFS) 2008.
• When configuring TFS, you can now specify a user name and password to log into TFS instead of using your Windows credentials.
• Improved handling of working directory initialization and handling of root folder and working directory.
• Support for multiple version control configurations that are active simultaneously.

 

---

Resolved Issues and Enhancements

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

Feature	Resolved Issue	Defect
Installation/ Upgrade	You can now install Toad on Windows Vista without performing a silent install.	ST#48360 CID#617034
Connections	MySQL now retains the database connection lock when starting an implicit transaction.	ST#65013
Data	When you enter a value in an auto-increment identity column, the value now acts as a placeholder until the change is submitted. Once the data is refreshed, the correct increment value replaces the placeholder value.	ST#52432
Debugger	The debugger no longer times out after stopping on a breakpoint.	ST#53041
	Clicking OK in the Debugger Start Parameters window without editing a value no longer results in an error.	ST#57164
	If you ignored some confirmation dialogs in the previous release, in some cases, the Debugger Start Parameters window did not display during a debugging session until you restarted Toad.	ST#53047
Editor	Settings specified in the Insert/Replace page under Tools | Options | Editor | Formatter are now applied to INSERT statements.	ST#50363
	Loading a saved script file that contains code regions no longer hangs Toad.	ST#59101 CID#694196 CID#690239
	Placing the cursor immediately before a semicolon in a statement no longer executes the statement that follows the selected one when pressing F9.	ST#58237
	Column names now display correctly when a query contains comments.	ST#63332
	You can now share formatter settings between team members by clicking Advanced in the Preview tab under Tools | Options | Editor | Formatter, and specifying a network share folder where settings are stored. Each team member must update their folder to point to the shared folder location and selected format.	ST#46425 CID#603026
ER Diagram	Setting the maximum objects to a value greater than the default value now correctly applies the setting.	ST#58479 CID#691496
Export Wizard/ One Click Export	When exporting large results sets (approximately 500K), Toad no longer runs out of memory before the operation completes.	ST#41935 CID#483802
Job Manager	The following note has been added to the "Schedule Windows Tasks" topic in the Job Scheduler help file (topic is available if the Job Manager is open): "Note: To manage windows tasks on a remote server you must have administrator privileges on the remote computer."	ST#42618 CID#558115
Object Explorer/ Database Explorer	If you create, alter, or drop an object using the Editor, those changes are now updated in the Object Explorer/Database Explorer.	ST#51495 ST#54816
	If you created a table using the Editor, adding a row using the data tab no longer results in a concurrency violation error when saving the change.	ST#58305
Project Manager	You can now add the "Add to Project Manager" button to a toolbar.	ST#57280 CID#680346
Query Builder	Update and Delete statements now include the Where clause in the Generated Query tabs.	ST#44655 ST#58344 CID#689012
	In the previous release, the online help incorrectly stated that you could not execute INSERT, UPDATE, or DELETE statements from the Query Builder.	ST#58345
Version Control	(TFS) The following issues have been resolved:  Toad now supports TFS 2008 If you have not selected a sub-project, attempting to add an object no longer results in an error.	ST#55362 CID#661375 CID#67201 CID#690923 ST#51033
	If you disable a version control configuration in Tools | Options | Version Control | General, and then enable the configuration, when you click OK a null reference error no longer displays.	ST#51933
	Selecting the "Do not check in after execute script in Editor" checkbox in Tools | Options | Version Control | General now correctly applies the setting.	ST#61262 CID#709009
	(Subversion) Toad has been tested with the CollabNet Subversion Command-Line Client 1.5.6 Notes:  Toad only supports Subversion 1.5.6 or later. Any Subversion client must have svn.exe in its installation directory to use version control in Toad. Tortoise SVN is no longer supported in Toad because it no longer includes svn.exe in its installation directory. See "Configure Subversion Version Control" in the Toad help for more information.	ST#56045 CID#694019 ST#55937 CID#667983
	When renaming an object in version control, Toad drops the original object from version control and prompts you to add the renamed object to version control Note that this newly renamed object does not have any history associated with it.	ST#41786 CID#448598

---

Known Issues

The following is a list of issues known to exist at the time of the Toad for MySQL release.

Feature	Known Issue	Defect
Installation/ Upgrade	Customized options selected in the Configuration wizard are not applied if you are running Toad as a Restricted user. Workaround: Customize these settings in the Options pages in Toad (Tools | Options from the menu)	ST#42154 CR#216699
	The Toad for MySQLInstallation Guide and online help incorrectly state that Toad supports read-only installation of the product.	N/A
Licensing	(Windows Vista only) The location where the license.key file is stored depends on whether User Account Control (UAC) is enabled in your Windows Vista environment when you install and initially launch Toad. With User Account Control (UAC) enabled  If you install Toad as an administrator and: Launch Toad directly from the Installer’s last page and enter the license key, the license.key file is saved in C:\Program Files\Quest Software\Toad for MySQL 4.5 Note: You can write to C:\Program Files because you still have administrator privileges. Exit the installer without launching Toad, then launch Toad from the Desktop shortcut or Windows Start menu and enter the license key, the license.key file is saved in the administrator's virtual store folder in: C:\Users\Admin\AppData\Local\ VirtualStore\Program Files\Quest Software\Toad for MySQL Note: You write to this folder because you run as standard user even if you logged in as an administrator. Exit the installer without launching Toad, switch to a standard user, launch Toad, and enter the license key, the license.key file is saved in the user’s virtual store folder: C:\Users\username\AppData\Local\ VirtualStore\Program Files\Quest Software\Toad for MySQL 4.5 With User Account Control (UAC) disabled  If you install Toad as an administrator and: Launch Toad from the last page of the installer, Desktop shortcut, or Windows Start menu, and enter the license key, the license.key file is saved in: C:\Program Files\Quest Software\Toad for MySQL 4.5 Exit the installer without launching Toad, switch to a standard user, then launch Toad from the Desktop shortcut or Windows Start menu and enter the license key, the license.key file is saved in: C:\Users\username\AppData\ Roaming\Quest Software\Toad for MySQL 4.5	N/A
Data	Attempting to right-click a row and selecting Row Count results in a message stating that the row count could not be determined.	ST#56586
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.	ST#41627 CR#164917
	Attempting to execute a "show innodb status" statement results in a "Net packets out of order" error message.	ST#41861 CR#193385
Export Wizard/ One Click Export	Blob and Binary data types cannot be exported in this release.	ST#41665 CR#170430
Import Wizard	Currently, you cannot import Excel 2007 files because they are saved using an xlsx format. Workaround: Save the Excel 2007 file as a 2003 compatible file before importing it.	ST#42416 CR#221667
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 appears to hang because it is waiting for you to either commit or rollback the current transaction. Workaround: Commit or rollback the editor transaction.	ST#55294
	Currently, you cannot filter databases or objects.	ST#46945
	When altering a table: The Columns page does not set the Unsigned property for Unsigned columns. Selecting the Show Script page more than once has no effect.	ST#48653 ST#43282
	Currently, BIGINT data types are not supported in the Data tab.	ST#46945
Query Builder	When reverse engineering a query from the Query tab or the Editor, the Diagram tab does not support a SELECT statement where the columns are qualified with the database name Workaround: When you visualize the query to display in the Diagram tab, Toad automatically creates calculated columns for the columns qualified with a database name. This allows you to execute the query and return the correct result set.	ST#49731
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.	ST#63004
	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
	On Subversion, adding a large number of objects can result in decreased performance.	ST#50279
	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."	ST#42093 CR#214601

---

Third Party Known Issues

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.	ST#41612 CR#160929
	Currently, if the value of a TIME data type is greater than 24-hours, the value does not display correctly.	N/A
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	CR#138239

 

---

System Requirements

Client Requirements

Before installing Toad for MySQL, ensure your client system meets the following minimum hardware and software requirements:

Platform	1 GHz minimum
Hard Disk Space	54 MB of disk space is required to run Toad.
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 Size and complexity of the database Amount of database activity Number of concurrent users accessing the database
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)
Additional Requirements	.NET Framework Microsoft .NET Framework 3.5 (Service Pack 1) Notes:  The .NET Framework Client Profile is not supported. To run Toad, the .NET security policy must be set to unrestricted. See for more information.  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)

Server Requirements

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

Operating System	Windows 2000 (Service Pack 4 or later) Windows 2003 Windows XP 32-bit and 64-bit Windows Vista 32-bit and 64-bit
Database Support	MySQL 5.1

Citrix Requirements

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.  

User Privilege Requirements

The following user privileges are required for installing and running Toad for MySQL:

• Only Power users and Administrators can install Toad.

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

• If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and the Toad menu option in the Windows Start menu with any user on the computer.
• To run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

1. From the Windows Start menu, select Settings | Control Panel.
2. Double-click Administrative Tools.
3. Double-click Microsoft .NET Framework 2.0 Configuration.
4. 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.
5. Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.
6. Browse to the location of Toad.exe in the File field.
7. Click Next to view permissions for Toad.exe.
8. Set the permission to Unrestricted.

Silent Install Requirements

Before you perform a silent installation, the following software must be installed on every system on which you are installing Toad:

• Microsoft .NET Framework 3.5 (Service Pack 1) or later

For information about installing Toad silently, see "Install Toad Silently" in the Installation Guide.

---

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

---

Installation

The Toad for MySQL release package contains the following products:

• Toad for MySQL version 4.5.0
• Product Documentation, including:
  • Installation Guide
  • Online Help
  • Release Notes

Installation Instructions

For general installation information, see the Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for MySQL | Documentation.