Software:Toad

From HandWiki
Revision as of 14:00, 26 July 2022 by imported>MainAI6 (url)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Short description: Database management software
TOAD
Toad-Original RGB.png
Original author(s)Jim McDaniel
Developer(s)Quest Software
Written inVarious (depending on the database used)
TypeDatabase management tools
LicenseProprietary
Websitehttps://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 (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).

See also

References

  1. ↑ Scalzo, Bert; Hotka, Dan (February 2003). Toad Handbook. Developer's Library. Jim McDaniel. Sams Publishing. p. xiv. ISBN 978-0-672-32486-4. https://books.google.com/books?id=eKwSVQ7kiaIC. Retrieved 2013-10-23. "I've been working on TOAD now for more than six years. Or has it been seven?" 
  2. ↑ "Quest Software's Acquisitions". Dell Inc.. Archived from the original on 2012-02-03. https://web.archive.org/web/20120203093601/http://www.quest.com/company/acquisitions.aspx. Retrieved 2013-03-05. 
  3. ↑ "Dell to Acquire Quest Software" (in en). http://www.businesswire.com/news/home/20120702005389/en/Dell-Acquire-Quest-Software. 
  4. ↑ "Quest Software, its Toad tool leaping over to Dell" (in en-US). SearchOracle. http://searchoracle.techtarget.com/news/2240159039/Quest-Software-its-Toad-tool-leaping-over-to-Dell. 
  5. ↑ Miller, Ron. "Confirmed: Dell sells software division to Francisco Partners and Elliott Management" (in en). TechCrunch. https://techcrunch.com/2016/06/20/confirmed-dell-sells-software-division-to-francisco-partners-and-elliott-management/. 
  6. ↑ "Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management" (in en). http://www.businesswire.com/news/home/20161101005616/en/Quest-Launches-Independent-Software-Company-Backed-Francisco. 

External links




Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Toad&oldid=328193"