Jump to content

Toad (software): Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
Edited to remove bias - point of view changed to keep factual without inserting opinion.
 
(286 intermediate revisions by more than 100 users not shown)
Line 1: Line 1:
{{Short description|Database management software}}
'''TOAD''' is a [[database administration]] and [[SQL]] development [[software application]], considered a de-facto tool of choice for Oracle [[Database administrator|DBA]]s (database administrators). TOAD is now available for the following databases: [[Oracle Database]], [[Microsoft SQL Server]], [[IBM DB2]], and [[MySQL]].
{{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|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 Database|Oracle]], [[Database server|SQL Server]], [[IBM Db2|IBM DB2]] (LUW & z/OS), [[Adaptive Server Enterprise|SAP]] and MySQL. A Toad product for data preparation supports many data platforms.
== Supported Operating Systems and Versions ==
TOAD runs on all [[32-bit]] [[Microsoft Windows|Windows]] platforms, including [[Windows 95]], [[Windows 98|98]], [[Windows NT|NT]], [[Windows 2000|2000]], and [[Windows XP|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, an [[open source]] variant of TOAD that is [[platform independent]] had been developed, dubbed [[TOra]].


== History ==
== 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|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]].
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]].


[[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>
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.


== Features ==
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.
* 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 ==
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 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==
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 demonstrate a lack of flexibility or excessive hardware requirements, sending DBAs and developers back to the SQL*Plus console.
* [[Comparison of database tools]]


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

A share of TOAD end-users expressed concerns with Quest's move to version 8 of the product. A Version 7.x (7.4 being the latest) was the last Delphi-based version of TOAD. There have been calls to release the Delphi product strand into [[open source]], though that seems unlikely due to Quest's proprietary rights.


== External links ==
== External links ==
* [http://www.toadsoft.com/ Official site]
* [http://www.toadworld.com/ Official Toad User Community]
* [http://www.quest.com/ Quest Software]
* [https://www.quest.com/toad/ Quest Software Toad] company website
* [http://www.quest.com/toad_for_oracle/ TOAD for Oracle]
* [http://www.quest.com/toad_for_sql_server/ TOAD for Microsoft SQL Server]
* [http://www.quest.com/toad_for_db2/ TOAD for IBM DB2]
* [http://www.quest.com/toad_for_mysql/ TOAD for MySQL]
* [http://www.mactech.com/news/?p=1001626 Quest Adds Toad to Suite of Oracle Developer Tools]
* [http://www.powells.com/cgi-bin/biblio?inkey=17-0596003374-0 Toad Pocket Reference for Oracle 1st Edition by Jim McDaniel and Patrick McGrath]
⚫
* [http://www.amazon.com/gp/product/0596009712 Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath]
* [http://www.amazon.com/gp/product/0672324865 TOAD Handbook by Bert Scalzo and Dan Hotka]
* [http://www.toadsoft.com/Engineering_Better_PLSQL.pdf Engineering Better PL/SQL (using Toad's CodeXpert) by Bert Scalzo]
* [http://www.asktoad.com AskToad.com - A Wiki based Toad for Oracle knowledge base site]
* [http://asktoad.com/DWiki/doku.php?id=faq:questions Toad FAQ - Frequent Question & Answer troubleshooting page]


{{Quest Software Inc}}
{{Authority control}}

[[Category:Programming tools]]
[[Category:Integrated development environments]]
[[Category:Desktop database application development tools]]
[[Category:Database administration tools]]
[[Category:Database administration tools]]
[[Category:Quest Software]]
[[Category:PL/SQL editors]]
[[Category:Oracle database tools]]

[[Category:Microsoft database software]]
[[de:TOAD]]
[[Category:Sybase]]
[[Category:MySQL]]

Latest revision as of 10:51, 30 April 2024

For other uses, see Toad (disambiguation).
TOAD
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

[edit]

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

[edit]
  • 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

[edit]
  • 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

[edit]

References

[edit]
  1. ^ Scalzo, Bert; Hotka, Dan (February 2003). Toad Handbook. Developer's Library. Jim McDaniel. Sams Publishing. p. xiv. ISBN 978-0-672-32486-4. 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. Retrieved 2013-03-05.
  3. ^ "Dell to Acquire Quest Software". www.businesswire.com (Press release). 2 July 2012. Retrieved 2017-11-30.
  4. ^ "Quest Software, its Toad tool leaping over to Dell". SearchOracle. Retrieved 2017-12-06.
  5. ^ Miller, Ron. "Confirmed: Dell sells software division to Francisco Partners and Elliott Management". TechCrunch. Retrieved 2017-11-30.
  6. ^ "Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliott Management". www.businesswire.com (Press release). November 2016. Retrieved 2017-11-30.
[edit]
Retrieved from "https://en.wikipedia.org/enwiki/w/index.php?title=Toad_(software)&oldid=1221510160"