Jump to content

Toad (software): Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
m * [http://www.toadsoft.com/ Official site]
 
(321 intermediate revisions by more than 100 users not shown)
Line 1: Line 1:
{{Short description|Database management software}}
'''TOAD''' is an [[Oracle database]] [[database administration|administration]] and [[SQL]] development [[software application]], considered to be a de-facto tool of choice for Oracle [[Database administrator|administrators]].
{{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, a [[Linux]] variant of TOAD 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.
[[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>
The tool was so useful that he made it available first as [[shareware]] and later as [[freeware]],

and distributed it freely over the [[Internet]].
== 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 ==
As the user base grew, so did the effort of maintenance and development. Finally, the author realized
* ''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}})
that he could no longer dedicate substantial amount of time to the growing quantity of software enhancement requests.
* ''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==
On [[November 9]] [[1998]] [[Quest Software]], a developer and distributor of a competitive TOAD's rival, [[SQL Navigator]], suddenly announced the addition of TOAD to its family of database development and management solutions for Oracle.
* [[Comparison of database tools]]


== References ==
Jim McDaniel, TOAD's creator, explained the move as: "I approached Quest Software
{{Reflist}}
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."


⚫
== External links ==
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 demonstrated a lack of flexibility or excessive hardware requirements, sending DBAs and developers back to SQL*Plus console.
⚫
* [http://www.toadworld.com/ Official Toad User Community]
* [https://www.quest.com/toad/ Quest Software Toad] company website


{{Quest Software Inc}}
⚫
== External Links ==
{{Authority control}}
⚫
* [http://www.toadsoft.com/ Official site]
* [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]


[[Category:Database management systems]]
[[Category:Programming tools]]
[[Category:Oracle Corporation]]
[[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]]

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"