Toad (software) explained

TOAD
Author:	Jim McDaniel
Developer:	Quest Software
Programming Language:	Various (depending on the database used)
Genre:	Database management tools
License:	Proprietary
Website:	https://www.quest.com/toad/

Toad is a database management toolset from Quest Software for managing relational and non-relational databases using SQL aimed at database developers, database administrators, and data analysts. The Toad toolset runs against Oracle, SQL Server, IBM DB2 (LUW & z/OS), SAP and MySQL. A Toad product for data preparation supports many data platforms.

History

A practicing Oracle DBA, Jim McDaniel, designed Toad for his own use in the mid-1990s.^[1] He called it Tool for Oracle Application Developers, shortened to "TOAD". McDaniel initially distributed the tool as shareware and later online as freeware.

Quest Software acquired TOAD in October 1998.^[2] Quest Software itself was acquired by Dell in 2012 to form Dell Software.^{[3] [4]} In June 2016, Dell announced the sale of their software division, including the Quest business, to Francisco Partners and Elliott Management Corporation.^[5] On October 31, 2016, the sale was finalized. On November 1, 2016, the sale of Dell Software to Francisco Partners and Elliott Management was completed, and the company re-launched as Quest Software.^[6]

Features

• Connection Manager - Allow users to connect natively to the vendor’s database whether on-premise or DBaaS.
• Browser - Allow users to browse all the different database/schema objects and their properties effective management.
• Editor - A way to create and maintain scripts and database code with debugging and integration with source control.
• Unit Testing (Oracle) - Ensures code is functionally tested before it is released into production.
• Static code review (Oracle) - Ensures code meets required quality level using a rules-based system.
• SQL Optimization - Provides developers with a way to tune and optimize SQL statements and database code without relying on a DBA. Advanced optimization enables DBAs to tune SQL effectively in production.
• Scalability testing and database workload replay - Ensures that database code and SQL will scale properly before it gets released into production.

Books

• Toad Pocket Reference for Oracle plsql 1st Edition by Jim McDaniel and Patrick McGrath, O'Reilly, 2002
• Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath, O'Reilly, 2005
• TOAD Handbook by Bert Scalzo and Dan Hotka, Sams, 2003
• TOAD Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 .
• TOAD Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 .

See also

• Comparison of database tools

External links

• Official Toad User Community
• Quest Software Toad company website

Notes and References

1. Book: Toad Handbook. Scalzo. Bert. Hotka. Dan. February 2003. Sams Publishing. Jim McDaniel. 978-0-672-32486-4. Developer's Library. xiv. I've been working on TOAD now for more than six years. Or has it been seven?. 2013-10-23.
2. Web site: Quest Software's Acquisitions. Dell Inc.. 2013-03-05. dead. https://web.archive.org/web/20120203093601/http://www.quest.com/company/acquisitions.aspx. 2012-02-03.
3. Dell to Acquire Quest Software. www.businesswire.com. 2 July 2012 . en. 2017-11-30.
4. News: Quest Software, its Toad tool leaping over to Dell. SearchOracle. 2017-12-06. en-US.
5. News: Confirmed: Dell sells software division to Francisco Partners and Elliott Management. Miller. Ron. TechCrunch. 2017-11-30. en.
6. Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management. www.businesswire.com. November 2016 . en. 2017-11-30.