Toad is a

database management In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and ana ...

toolset from

Quest Software Quest Software, also known as Quest, is a privately held software company headquartered in Aliso Viejo, California, United States. Quest provides cloud management, software as a service, security, workforce mobility, and backup & recovery. The co ...

for managing relational and non-relational databases using

SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

aimed at database developers, database administrators, and data analysts. The Toad toolset runs against

Oracle An oracle is a person or thing considered to provide insight, wise counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. If done through occultic means, it is a form of divination. Descript ...

, SQL Server, IBM DB2 (LUW &

z/OS z/OS is a 64-bit operating system for IBM z/Architecture mainframes, introduced by IBM in October 2000. It derives from and is the successor to OS/390, which in turn was preceded by a string of MVS versions.Starting with the earliest: ...

), SAP and

MySQL MySQL () is an Open-source software, open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A rel ...

. 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. He called it ''Tool for Oracle Application Developers'', shortened to "TOAD". McDaniel initially distributed the tool as

shareware Shareware is a type of proprietary software that is initially shared by the owner for trial use at little or no cost. Often the software has limited functionality or incomplete documentation until the user sends payment to the software developer. ...

and later online as

freeware Freeware is software, often proprietary, that is distributed at no monetary cost to the end user. There is no agreed-upon set of rights, license, or EULA that defines ''freeware'' unambiguously; every publisher defines its own rules for the free ...

acquired TOAD in October 1998. Quest Software itself was acquired by

Dell Dell Inc. is an American technology company that develops, sells, repairs, and supports personal computers (PCs), Server (computing), servers, data storage devices, network switches, software, computer peripherals including printers and webcam ...

in 2012 to form

Dell Software Dell Software was a former division of Dell with headquarters in Round Rock, Texas, United States. Dell Software was created by merging various acquisitions (mainly Quest Software and Sonicwall) by Dell Inc., the third-largest maker of PCs and ...

. In June 2016, Dell announced the sale of their software division, including the Quest business, to

Francisco Partners Francisco Partners Management, L.P., doing business as Francisco Partners, is an American private equity firm focused exclusively on investments in technology and technology-enabled services businesses. It was founded in August 1999 and based in ...

and Elliott Management Corporation. 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.

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 Code review (sometimes referred to as peer review) is a software quality assurance activity in which one or more people examine the source code of a computer program, either after implementation or during the development process. The persons perf ...

(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 (, ).

References

External links

Official Toad User Community

Quest Software Toad
company website {{Authority control Programming tools Integrated development environments Desktop database application development tools Database administration tools PL/SQL editors Oracle database tools Microsoft database software Sybase MySQL

History

Features

Books

See also

References

External links