Toad (software)

TOAD is a database administration and SQL development software application, considered a de-facto tool of choice for Oracle DBAs (database administrators). TOAD is now available for the following databases: Oracle Database, Microsoft SQL Server, IBM DB2, and MySQL.

Supported Operating Systems and Versions

TOAD runs on all 32-bit Windows platforms, including Windows 95, 98, NT, 2000, and XP. Hardware requirements are such that if you can run the operating system, TOAD will probably run. For backend connectivity you will need Oracle 32-bit SQL*Net and Oracle version 7.3.4 or later.

There is no support for any non-Microsoft environment. Instead, a open source variant of TOAD that is platform independent had been developed, dubbed TOra.

History

TOAD was originally designed by a practicing Oracle developer, Jim McDaniel TOADman, in order to make his own life easier. He called it "Tool for Oracle Application Developers", TOAD for short. The tool was so useful that he made it available first as shareware and later as freeware, and distributed it freely over the Internet.

As the user base grew, so did the effort of maintenance and development. Finally, the author realized that he could no longer dedicate substantial amount of time to the growing quantity of software enhancement requests.

On November 9 1998 Quest Software, a developer and distributor of a competitive, related product, SQL Navigator, suddenly announced the acquisition of TOAD as an addition to its family of database development and management solutions for Oracle.

Jim McDaniel, TOAD's creator, explained the move as: "I approached Quest Software because it is a great company with a commitment to quality products. They also have an outstanding reputation for customer support and a very loyal user following not unlike that of TOAD."

It remains the most successful Oracle database administration tool in the DBA community, despite Oracle's own software, such as Oracle Developer, SQL Station, and many others, that demonstrated a lack of flexibility or excessive hardware requirements, sending DBAs and developers back to SQL*Plus console.

More recently, TOAD has been expanded to other database platforms such as Microsoft SQL Server, DB2, and MySQL.

A share of TOAD fans and users expressed concerns with Quest's move to version 8 of the product. A Delphi-based version 7.4 is believed to be the last "genuine" and easy-to-use revision of TOAD. There have been calls to release the Delphi product strand into open source, though that seems unlikely due to Quest's proprietory rights.

External links

• Official site
• Quest Software
• TOAD for Oracle
• TOAD for Microsoft SQL Server
• TOAD for IBM DB2
• TOAD for MySQL
• Quest Adds Toad to Suite of Oracle Developer Tools
• Toad Pocket Reference for Oracle 1st Edition by Jim McDaniel and Patrick McGrath
• Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath
• TOAD Handbook by Bert Scalzo and Dan Hotka
• Engineering Better PL/SQL (using Toad's CodeXpert) by Bert Scalzo
• AskToad.com - A Wiki based Toad for Oracle knowledge base site
• Toad FAQ - Frequent Question & Answer troubleshooting page