New in AQT v11

AQT v11 was released on the 14th August 2022.

Major new features

Save Sessions

AQT can save the state of your AQT session. This will be reestablished the next time you start AQT.

  • AQT can save your session either when AQT is closed, or manually with File > Save Session.
  • you can save a session permanently, and reopen it at a later date. This is very useful if you have a particular job function you need to return to from time to time.
  • AQT has an auto-save option. With this, the state of your session is saved periodically. This prevents your work from being lost in case of a machine crash or reboot.

Parameters

This is a powerful feature of AQT and we have added a number of new features.

There is now a dialog for adding a parameter to your query.

When your query has parameters, the parameters will be shown in a panel on the Data Display window. This makes it very easy to rerun the query with new parameter values.

A parameter dropdown query can depend on the value of an earlier parameter. This allows you to build more powerful dialogs for prompting for parameter values.

Export Multiple Tables

This features allows you to export all tables in a schema in a single operation.

  • you can export to csv, Excel, SQL as per the existing Data Export
  • you can specify which tables are to be exported, or apply a filter to export a particular subset
  • Export Multiple can be scripted, so can be included in a batch job

Export History

AQT will now maintain a history of exports. This is useful to keep track of all your export files.

Manage Batch Jobs

AQT will now make it easy to setup, run and manage your batch jobs.

  • there is a dialog for creating a batch job
  • there is a window to view your batch jobs
  • AQT will maintain a history of batch jobs run
  • you can now schedule the running of a batch job. This uses the Windows Task Scheduler.

License Server

As an alternative to the Activation system, AQT will allow selected customers to use a License Server

  • the License Server will run at the customer's site; machines will not need to access an internet resource
  • as AQT will contact the License Server every day, it will be easy to identifier users who are no longer using AQT or have left the company
  • the customer will be able to manage the use of the license themselves, including the ability to delete inactive users

Minor new features

Export to Grid

You can export to a grid. This is useful when running a query in a batch process - either overnight or because it is a long-running query. The results will go to a display grid, just as if you had run the query from interactive AQT.

The grid can be opened in AQT from the Export History or Batch History windows.

Merge Table

The Merge statement is a powerful statement for updating / inserting / deleting rows in a table based on the contents of another table. AQT v11 has a dialog for helping build a Merge statement.

Open CSV File

AQT now has a dialog for opening a CSV file. This is useful if you regularly deal with CSV files.

Data Compare script run

You can now specify that Data Compare automatically runs the resync script.