Advanced Query Tool
    About Us
    Users' Comments
  Future Releases
    Guided Tour
    How to Purchase
    Sign Guestbook
    View Guestbook
    AQT Forum
    Privacy Policy

Features in future releases

Please let us know what features you would like to see in AQT.

  • if you currently use AQT, let us know what extra features you would most find useful.
  • if you evaluated AQT but found that it didn't do what you wanted . . . let us know what it was and we will think about incorporating such features in a future release.

Feedback is generally appreciated.

Version 8 - due early to mid 2006

This will have the following new features:

  • a system-monitor window. This will show you internal information on your database, such as active tasks, locks and other internal information.
  • favorites. You will be able to to define tables / views and other objects as being a favorite. The Database Explorer will allow you to display either your the database Object Tree, or the Favorites list. You will also be able to define a saved-query as a favorite.
  • a new look. We are planning to implement a new menu / toolbar component. This will give AQT a more "modern" appearance, and will allow you to customise the items in the menus and toolbars.
  • wizards for building Where clauses, IN lists, CASE statements.
  • link to related tables. This will allow you to navigate between tables which have a defined relationship. For instance, if there is a relationship between customers and orders, when displaying a customer you can easily show the orders for that customer.
  • for Oracle we will have a window for displaying DBMS_OUTPUT.
  • the Data Loader will have an insert-update mode. With this, if a row already exists in the target table, it will be updated.

Earlier releases

Version 7 - released 28 Feb 2005

This had the following new features:

  • Unicode support. Allows AQT to display data from non-ascii character sets. This includes languages such as Japanese, Korean, Chinese, Hebrew, Maori etc.
  • Cancel queries Currently this feature is only available for databases whose ODBC Driver supports async queries. AQT v7 has introduced multi-threading, so that Cancel queries are available for all databases, including Oracle, Sybase, Informix and DB2 v8. This has been a technically complicated change.
  • Compare Table Data AQT v7 has added a tool to compare data between tables (more)
  • Compare Object Definition The previous Compare Tables function has been extended to compare more attributes of the table definition, and to compare objects other than tables (more)
  • XML Export You can export table data in XML format. This export conforms to the dbunit specifications.
  • Improved HTML Export HTML export has more options for formatting the HTML, plus support for style sheets (example)
  • Support for LOBs in Export Exports to HTML and Excel can export LOBs as files, and hyperlink to them (example)
  • Redesigned SQL Window The SQL window will (optionally) show you the keyword-grids on the right (instead of below). It can also show you the results in this window (rather than a new window).
  • Search Table function This new window provides a quick way of building simple searches on tables (screenshot)
  • SQL History This feature has been enhanced in a number of areas: statements will be saved to disk immediately (not just when AQT shuts down), an unlimited number of statements will be saved (not just the last 200), you will be able to have different history files per day, week or month.

Cross Database Features

This version has added a number of features that make it easier to manage or migrate tables between databases of different types:

  • when creating a table, you can Copy the definition from an existing table. With v7, this Copy From function now allows you to copy the definition from a table of a different database-type. For instance you can create a DB2 table with the same definition as an Oracle table.
  • the Gen DDL function allows you to gen the DDL for a database type. For instance, you can gen the DDL for a DB2 table in Sybase syntax.
  • the Compare Object function allows you to compare the definition of tables / indexes between databases of different types.
  • The Data Loader now has an option to automatically create the table being loaded. When loading data from one database to another, the table will be created with a definition.


  • These functions will deal with differences in the data types between different databases, however there are limits to this. Some databases have data types for which there are no equivalents in other databases.
  • Similarly, there are many attributes of tables, columns and indexes (such as tablespace, locking mode, page size) which have no equivalent in other databases, so these attributes will not be migrated.
  • Nor will these functions rewrite Stored Procedures or Triggers from one database language to another. We have had many enquiries about this, however it is well beyond the scope of AQT!

Windows 95/98/ME

AQT v7 cannot run on Windows 95, 98 and ME, as these versions of Windows do not support the Unicode functions used by AQT. At this stage we will continue the availabillity of AQT v6 for these operating systems.

Version 6 - released 1 April 2004

With this version we added many more DBA features to AQT. You can read a summary of the new features in the Extended Edition or go straight to screenshots using these links:

Version 5.5 - released 31 Mar 2003

With this version we added two often-requested features:

  • Syntax Highlighting of SQL. We have implemented a new Edit control that has syntax highlighting of your SQL. This makes a large difference to the readability of SQL. Click here for an example of what this looks like.
  • Inline Edit of Data. This allows you to edit tables directly in the Table Display window.

Version 5.3 - released 2 December 2002

  • the major new feature of this release is a new Grid control (DataDynamics #Grid). This gives AQT an improved look and feel, and adds many extra features.
  • you can use the Grouping feature of the grid control to automatically group your data by a particular column. See here for an example of what this looks like.
  • we have added a Pivot function. If you are summarising your data by two columns or more, you can use Pivot to transform your data into a tabular format which is easier to interpret. See here for an example of this.
  • Audit Facility. You can use this feature to audit all SQL run by AQT. You can audit all SQL, or just non-select statements. If you are doing critical updates in a production environment, this feature provides a valuable record of your activity.
  • Read-only mode. AQT can be configured to run in read-only mode. In this mode, only Select statements can be run - any other SQL statement will be rejected. This is useful when deploying AQT to users who do not require the full power of AQT.
  • Explain-Plan for DB2/390 and MySQL.
  • Support for Pervasive.SQL has been added.

Version 5.2 - released 22 July 2002

In Version 5.2 we have made significant improvements in the ability to compare the definition of tables between two schemas.

  • there is now a new function Compare all Tables in Schema. This will automatically compare the definitions of all tables in two Schemas, and show the differences in an easy-to-view window.
  • see here for an example of what this function looks like.
  • this function can be run in batch mode - this means that you can run a batch script that produces a report on the differences between two schemas.

Version 5.1 - released 4 June 2002

In Version 5.1 we have added:

  • the ability to have connections to multiple databases from one AQT session.
  • you can have multiple Table/Query display windows open at the same time
  • in addition you are able to have multiple Run SQL and GUI Query Builder windows open
  • you can run a GUI query without exiting the Query Builder window
  • more options with the Compare Tables feature
  • batch mode operation of AQT has been added. This allows you to run AQT queries in unattended (batch) mode.
  Go Home Go to Top

Last updated on 2 August 2005   

Copyright 2002-2005 Cardett Associates Ltd. All rights reserved.