|
|
|
|
|
This software was checked for viruses and was found to contain no viruses.
Click here
to see antivirus report.
|
|
| |
|
|
Video tutorial for Quest Software Toad for MySQL Freeware 6.0
|
Review
This is official description
Toad for MySQL Freeware is a tool that improves the productivity of developers and administrators by providing an easy-to-use development environment.
With Toad, developers and database administrators can use a familiar, proven tool to manage MySQL databases.
The following review written by one of the Software Informer contributors applies to version 4.5
Toad for Mysql is a database administration program developed by Quest Software. The software includes a database administration program, a query browser and an SQL editor. The great thing about Toad is that you can design, administer and manage everything with the help of the same package.
Toad includes a diagram builder, so you can design your database by selecting relationships, schemas and even data types. Once this is done, you can use the editor to create tables with the constraints you have chosen. Afterwards, you can administer the database using the inbuilt browser, which allows you to view and modify objects. However, the core of the program might be the query builder, which also allows you to add syntax for other languages, so that you can apply syntax highlighting to your code.
On the whole, the program is very powerful and contains a large amount of features built specifically for MySQL. However, although it claims to have an intuitive interface, the controls have a steep learning curve. Still this tool works great and may be ideal for DBAs looking for better tools. |
- Database design feature.
- Great database administrator and query browser.
|
- Confusing Interface.
- Weird execution mode.
|
|
Reviewed by: Ismael Mireles Reviewer rating: Reviewed: Last year
|
What's new in version 6.0
Toad now supports Excel 2010.
You can set the File History Size option to zero to reduce the amount of time required to load the File menu in Tools | Options | Options | Environment - General.
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.
Script Settings
You can now select whether the entire script stops or continues if an error occurs in any activity.
You can set whether the script and all its activities use relative or absolute paths. This is useful if you want to share your automation scripts with colleagues, want to place them on a shared network folder, or use them with version control.
You can also embed the actual SQL if you select SQL files in the Embed Input Files field. This also makes it easier to share the script with colleagues.
Database Activities
For the Select to File, Execute Script, and Select to Editor with Results database activities, you can now manually enter SQL
Import and Export activities no longer require a connection.
You can now export to an existing Excel Macro Enabled File (.xlsm) using the Export Activity.
If Verbose logging is selected in Script Settings, you can now view the progress of the import or export in real-time in the Output window.
File Activities
A new Run Automation Script activity lets you run another automation script (.tas file) in your current automation script.
You can now add multiple items to the Find and Replace activity.
You can use HTML as the body of your email when using the Send Email activity. To do so, use the Toad Report activity and select HTML as the output format type. You can then select that HTML file as the body for the email.
If you have an Import Wizard activity, and specify a file to save unimported rows to a discard file on the Save Settings as Template page, you can add the results of the discard file as an attachment to the Send Email activity.
The FTP activity includes the following enhancements:
You can use conditions to check if the local or remote directory or file exists. If you set a condition, the FTP activity only runs if the conditions you specify are met. For example, you would select RemoteFileExists if a vendor places a file on the FTP site each week that contains a mailing list that you need to import into a table, and create a report from.
System Activities
A new Pause activity stops an activity for a set number of seconds before continuing. This is useful if you are using parallel activities and need to wait a few seconds for the results of one branch to for a record to populate while the other branch is waiting for record to export data.
You can now add multiple variables to the Set Variable activity.
If you do not want to enter a value in this window, you can also enter a SQL statement to use as the variable. If you enter a statement, the value from the first row and column returned in the query is used as the variable value. This is useful if you need a variable with a date.
The Run Program activity includes the following enhancements:
Applications are now opened as minimimized.
The Arguments field now supports variables.
Note: You must enclose variables with a # sign (for example, #sleep#).
The Arguments field also supports running macros in Access databases. If you want to run a macro in Access, enter databasename /x macroname in this field. For example, if you have a macro that beeps when run in your Northwind database, you would enter Northwind 2007.accdb /x beep.
You can now add a Parallel activity to a connection.
Histogram Tool
The new Histogram tool allows you to visualize the frequency distribution of data. Right-click on any data grid to access the Histogram tool.
Import Wizard
You can now specify the import data block size by entering a value for the Process Row Count in the Import Wizard. This enhancement allows you to customize the import process by adjusting the number of rows to process at one time.
You can now specify a Default On Error value in the Import Wizard. Add a default value that Toad for MySQL will enter into cells where data import failed. Use the value to easily find import errors.
Creating Data Reports
The Data Reports feature has been enhanced to include new functionality.
After customizing a report layout, you can now save the report layout as a template to use for generating subsequent reports.
You can now include multiple data sets in one Data Report by using multiple queries.
You can now edit data from inside the Report Designer by selecting the Data tab at the bottom of the window. (In previous versions of Toad for MySQL, editing data in a report required sending the query to the Master Detail Browser.)
Improved Chart Designer
In addition to one-click charts, Toad for MySQL's Chart Designer has been streamlined to create charts even faster. You can now create a chart in a data report with only a few clicks using the Chart Designer. You can then save your report or continue to modify the chart using the Chart Wizard. Chart Designer retains the features available in previous versions of Toad for MySQL.
One-Click Charting
Now you can quickly create charts and graphs from any data grid with one-click charts. Simply right-click on any data grid and select one of the following:
Quick Export | Excel Instance Chart to instantly create a chart in Excel. You can then further modify the chart in Excel and save it as an Excel file.
Send to | Chart Designer to create a new Toad for MySQL Data Report containing the chart. You can then further modify the chart using Data Report's Chart Wizard. |
|
Report a wrong version
Report a wrong program title
Suggest a correction
|
Screenshots
All 6 screenshots |
|
|
|
