Advanced Query Tool is a Microsoft Windows based SQL query software tool used to administer and… Created by Cardett Associates 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….
Find Top 10
Advanced Query Tool
Alternatives
# | Image | App Name | Features | Platforms | Price | Website Link |
1 | MySQL Workbench | Windows | Free | Website | ||
2 | Execute Query | Linux Windows |
Free | Website | ||
3 | HeidiSQL Alternatives and Similar Software | Windows | Free | Website | ||
4 | Windward Studios | Web | Mac Java Mobile Windows Self-Hosted Linux |
Commercial | Website | |
5 | JasperReports | Mac Windows Linux |
Commercial | Website | ||
6 | GridGain In-Memory Data Fabric | Linux Windows |
Commercial | Website | ||
7 | Pentaho | Linux Windows |
Commercial | Website | ||
8 | Oracle SQL Developer | Mac Windows Linux |
Free | Website | ||
9 | SpagoBI | Linux Windows |
Free | Website | ||
10 | SQuirreL SQL | Mac Windows Linux |
Free | Website |