Toad (software)

From Wikipedia, the free encyclopedia
(Redirected from TOAD (software))
Jump to navigation Jump to search
TOAD
Original authorJim McDaniel
DeveloperQuest Software
Repository
  • {{URL|example.com|optional display text}}Lua error in Module:EditAtWikidata at line 29: attempt to index field 'wikibase' (a nil value).
Written inVarious (depending on the database used)
Engine
    Lua error in Module:EditAtWikidata at line 29: attempt to index field 'wikibase' (a nil value).
    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 | edit source]

    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 | edit source]
    • 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 | edit source]
    • Toad Pocket Reference for Oracle plsql 1st Edition by Jim McDaniel and Patrick McGrath, O'Reilly, 2002 (Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).)
    • Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath, O'Reilly, 2005 (Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).)
    • TOAD Handbook by Bert Scalzo and Dan Hotka, Sams, 2003 (Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).)
    • TOAD Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 (Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).).
    • TOAD Handbook 2nd Edition by Bert Scalzo and Dan Hotka, Addison-Wesley Professional, 2009 (Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).).

    See also

    [edit | edit source]

    References

    [edit | edit source]
    1. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    2. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    3. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    4. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    5. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    6. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    [edit | edit source]

    Lua error in Module:Authority_control at line 153: attempt to index field 'wikibase' (a nil value).