Toad (software): Difference between revisions

This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources: "Toad" software – news · newspapers · books · scholar · JSTOR (August 2008) (Learn how and when to remove this message)

Toad is a database administration and SQL development software application from Quest Software. It is widely used by Oracle developers and DBAs (database administrators).^{[citation needed]} Toad is now available for the following databases: Oracle Database, Microsoft SQL Server, IBM DB2, and MySQL.

Toad runs on all 32-bit Windows platforms, including Windows 95, 98, NT, 2000, XP, and Vista. 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.

Toad can view the Oracle Dictionary, tables, indexes, storedprocedures, and more-- all through a multi-tabbed browser.

There is no support for any non-Microsoft environment. Quest does, however, have an open source platform independent tool offering some of Toad's basic functionality, called TOra.

Toad is available in both commercial and freeware versions. The freeware version requires reinstalling every 60 days. However, Toad for SQL Server Freeware and Toad for MySQL are freeware and never expire.

Toad was originally designed by a practicing Oracle developer, Jim McDaniel (aka "TOADman"), in order to make his own life easier. He called it Tool for Oracle Application Developers, TOAD for short. The tool was made available to others first as shareware and later as freeware, and McDaniel 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 amounts 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, 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: "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."

Toad remains the most successful database development and administration tool for Oracle database professionals, despite competition from Oracle's own software offerings, and those of other vendors.

In 2004, Quest re-branded the tool to accommodate product line expansion into other database platforms. Toad was registered as a Trademark and is no longer an acronym. Toad comes in five platform editions: Toad for Oracle, Toad for SQL Server, Toad for IBM DB2 LUW, Toad for IBM DB2 z/OS and Toad for MySQL.

• Toad Pocket Reference for Oracle 1st Edition by Jim McDaniel and Patrick McGrath, O'Reilly, 2002 (ISBN 0596003374, ISBN-13 978-0596003371)
• Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath, O'Reilly, 2005 (ISBN 0596009712, ISBN-13 978-0596009717)
• TOAD Handbook by Bert Scalzo and Dan Hotka, Sams, 2003 (ISBN 0672324865, ISBN-13 978-0672324864)

• Comparison of database tools

• Official User Community
• Official site
• Quest Software
• Toad for Oracle
• Toad for SQL Server
• Toad for IBM DB2
• Toad for MySQL
• Quest Adds Toad to Suite of Oracle Developer Tools
• Engineering Better PL/SQL (using Toad's CodeXpert) by Bert Scalzo
• Setup and Use Toad in a Secure Database Environment by Bert Scalzo
• Maximize DB Performance via Toad by Bert Scalzo
• AskToad.com - A Wiki based Toad for Oracle knowledge base site
• Toad FAQ - Frequent Question & Answer troubleshooting page
• Toad 9 - default options which should be changed