{{Short description|Database management software}} {{Other uses|Toad (disambiguation)}} {{more citations needed|date=September 2016}} {{Infobox software | name = TOAD | logo = Toad-Original RGB.png | caption = | author = Jim McDaniel | developer = Quest Software | latest release version = | latest release date = | latest preview version = | latest preview date = | status = | programming language = Various (depending on the database used) | platform = | language = | 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.<ref>{{cite book|url=https://books.google.com/books?id=eKwSVQ7kiaIC|title=Toad Handbook|last1=Scalzo|first1=Bert|last2=Hotka|first2=Dan|date=February 2003|publisher=Sams Publishing|others=Jim McDaniel|isbn=978-0-672-32486-4|series=Developer's Library|page=xiv|quote=I've been working on TOAD now for more than six years. Or has it been seven?|accessdate=2013-10-23}}</ref> 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.<ref>{{cite web|url=http://www.quest.com/company/acquisitions.aspx|title=Quest Software's Acquisitions|publisher=Dell Inc.|accessdate=2013-03-05|url-status=dead|archiveurl=https://web.archive.org/web/20120203093601/http://www.quest.com/company/acquisitions.aspx|archivedate=2012-02-03}}</ref> Quest Software itself was acquired by Dell in 2012 to form Dell Software.<ref>{{Cite press release|url=http://www.businesswire.com/news/home/20120702005389/en/Dell-Acquire-Quest-Software|title=Dell to Acquire Quest Software|website=www.businesswire.com|date=2 July 2012 |language=en|access-date=2017-11-30}}</ref><ref>{{Cite news|url=http://searchoracle.techtarget.com/news/2240159039/Quest-Software-its-Toad-tool-leaping-over-to-Dell|title=Quest Software, its Toad tool leaping over to Dell|work=SearchOracle|access-date=2017-12-06|language=en-US}}</ref> In June 2016, Dell announced the sale of their software division, including the Quest business, to Francisco Partners and Elliott Management Corporation.<ref>{{Cite news|url=https://techcrunch.com/2016/06/20/confirmed-dell-sells-software-division-to-francisco-partners-and-elliott-management/|title=Confirmed: Dell sells software division to Francisco Partners and Elliott Management|last=Miller|first=Ron|work=TechCrunch|access-date=2017-11-30|language=en}}</ref> 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.<ref>{{Cite press release|url=http://www.businesswire.com/news/home/20161101005616/en/Quest-Launches-Independent-Software-Company-Backed-Francisco|title=Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management|website=www.businesswire.com|date=November 2016 |language=en|access-date=2017-11-30}}</ref>
== 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 ({{ISBN|0596003374}}, {{ISBN|978-0-596-00337-1}}) * ''Toad Pocket Reference for Oracle 2nd Edition'' by Jeff Smith, Bert Scalzo, and Patrick McGrath, O'Reilly, 2005 ({{ISBN|0596009712}}, {{ISBN|978-0-596-00971-7}}) * ''TOAD Handbook'' by Bert Scalzo and Dan Hotka, Sams, 2003 ({{ISBN|0672324865}}, {{ISBN|978-0-672-32486-4}}) * ''TOAD Handbook 2nd Edition'' by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 ({{ISBN|0321649109}}, {{ISBN|978-0-321-64910-2}}). * ''TOAD Handbook 2nd Edition'' by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 ({{ISBN|0321649109}}, {{ISBN|978-0-321-64910-2}}).
==See also== * Comparison of database tools
== References == {{Reflist}}
== External links == * [http://www.toadworld.com/ Official Toad User Community] * [https://www.quest.com/toad/ Quest Software Toad] company website
{{Quest Software Inc}} {{Authority control}}
Category:Programming tools Category:Integrated development environments Category:Desktop database application development tools Category:Database administration tools Category:PL/SQL editors Category:Oracle Database tools Category:Microsoft database software Category:Sybase Category:MySQL