Toad is a

database management In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases spa ...

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

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 Sap is a fluid transported in xylem cells (vessel elements or tracheids) or phloem sieve tube elements of a plant. These cells transport water and nutrients throughout the plant. Sap is distinct from latex, resin, or cell sap; it is a separ ...

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

freeware Freeware is software, most 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 t ...

acquired TOAD in October 1998. Quest Software itself was acquired by Dell in 2012 to form

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

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

Francisco Partners Francisco Partners is an American private equity firm focused exclusively on investments in technology and technology-enabled services businesses. Founded in August 1999 and based in San Francisco with offices in London and New York City, Francis ...

and

Elliott Management Corporation Elliott Investment Management is an American investment management firm. It is also one of the largest activist funds in the world. It is the management affiliate of American hedge funds Elliott Associates L.P. and Elliott International Limit ...

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

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