Toad is a database management toolset from Quest Software that database developers, database administrators, and data analysts use to manage both relational and non-relational databases using SQL. There are Toad products for developers and DBAs, which run onOracle, SQL Server, IBM DB2, SAP and MySQL, as well as, a Toad product for data preparation, which supports most data platforms. Toad solutions enable data professionals to automate processes, minimize risks, and cut project delivery time.
History
Jim McDaniel, a practicing Oracle DBA, originally designed Toad for his own use in the mid-1990s. He called it Tool for Oracle Application Developers: "TOAD" for short. McDaniel made the tool available to others first as shareware and later as freeware, distributing it freely over the Internet. As the user base grew, so did the effort of maintenance and development. Finally, McDaniel realized that he could no longer dedicate substantial amounts of time to the growing quantity of software enhancement requests. Quest Software, established in 1987, acquired TOAD in October 1998. Quest Software was acquired by Dell in 2012 to form Dell Software. In June 2016, Dell announced the sale of their software division, including the Quest business, to Francisco Partners 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. Toad products are currently part of the Quest Software portfolio.
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 - Ensures code is functionally tested before it is released into production.
Static code review - 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.
