What is Advanced Query Tool?
Advanced Query Tool is a Microsoft Windows based SQL query software tool used to administer and execute queries against the most common database management systems. AQT is created by a small New Zealand software company, Cardett, and is distributed and supported through the Internet. AQT is designed for use by database administrators and developers.ArchitectureAQT is a Windows application that uses ODBC to access the data, but is aware of the catalog structures of most common databases. This sets it apart from most software tools that use ODBC. The ODBC catalog is very slow on large systems, but AQT directly queries the catalog meta data of well known data base management systems, which makes it very fast for exploring the data structures of enterprise size data bases.Catalog awareness is accomplished by using configuration files for each flavor of DBMS to define the queries to run against the data base catalog meta data. There are also separate configuration files for the administration component.Data Base Management Systems of which AQT is aware of the catalog structure include IBM DB2, Oracle, Microsoft SQL Server, Postgres, MySQL, Sybase, and Informix.LicenseThere are two levels of licensing of AQT: the Standard License, which allows most functionality, and the Extended License, which allows full use including the administration tools, data compare, and the data loader.
Show full description ▾
Features Vote on or suggest new features
Comments and Reviews Post a comment / review all • positive • negative relevance • date
Advanced Query Tool
Our users have written 5 comments and reviews about Advanced Query Tool, and it has gotten 4 likes
- Developed by Cardett Associates
- Proprietary and Commercial product.
- Average rating of 4.8
- 44 alternatives listed
Popular alternativesView all
Advanced Query Tool was added to AlternativeTo byon Apr 23, 2013 and this page was last updated Aug 17, 2018. Advanced Query Tool is sometimes referred to as AQT.