- 论坛徽章:
- 0
|
New in This Release
Review the following sections for updates in this release and new features:
Prerequisites/Installation
General
Automation
Database Administration
Data Management
Query Development
Project Management
Version Control
Prerequisites/Installation
Toad now requires .NET Framework 3.5 (Service Pack 1) or later. You can download the latest .NET Framework at:
http://www.microsoft.com/Net/Download.aspx
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.
[color="#010100"]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 queryGenerate repetitive reports where only the product number, date, region, or any other single element changesCustomize 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.
Back to Top
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#48360CID#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#59101CID#694196CID#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#46425CID#603026
ER Diagram
Setting the maximum objects to a value greater than the default value now correctly applies the setting.
ST#58479CID#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#41935CID#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#42618CID#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#51495ST#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#57280CID#680346
Query Builder
Update and Delete statements now include the Where clause in the Generated Query tabs.
ST#44655ST#58344CID#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 2008If you have not selected a sub-project, attempting to add an object no longer results in an error.
ST#55362CID#661375CID#67201CID#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#61262CID#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#56045CID#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#41786CID#448598
Back to Top
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#42154CR#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#41861CR#193385
Export Wizard/ One Click Export
Blob and Binary data types cannot be exported in this release.
ST#41665CR#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#42416CR#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#42093CR#214601
Back to Top
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#41612CR#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
http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en
2007 PIAs
http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en
CR#138239
Back to Top
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 ToadSize and complexity of the databaseAmount of database activityNumber 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
User Requirements
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
DatabaseSupport
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:
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.
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.
Back to Top
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.
Back to Top
Installation
The Toad for MySQL release package contains the following products:
Toad for MySQL version 4.5.0Product Documentation, including:
Installation GuideOnline HelpRelease 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.
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u3/103730/showart_2055457.html |
|