Moving AQT to a new machine

If you wish to install AQT on a new machine, the procedure is as follows:

• install AQT on the new machine
• enter your AQT license
• activate your license
• if required, copy your AQT settings and files from your old machine

Once AQT is running to your satisfaction on the new machine:

• deactivate your license from the old machine
• uninstall AQT from the old machine

To connect to your databases on the new machine you will need to:

• install database client software and/or ODBC drivers on your new machine
• set up ODBC Datasource definitions for your databases

Licensing

AQT is licensed by user. You may install AQT on multiple machines, as long as it is only used by yourself. There is no problem with having AQT installed on your old machine plus new machine at the same time.

Copy your AQT settings

• On the old machine, go to the Options window and select File > Export All Options
• Copy the options file to the new machine
• On the new machine, go to the Options window and select File > Import Options. Specify the options file you copied from the old machine.
• Review the setting for Options > File Locations to ensure the directories are valid for the new machine

Copy your AQT License Key

We provide no mechanism for doing this. It is strongly recommended that you retain a copy of your license key for installation on a new machine.

For more info see Lost your registration Key?

Copy your Queries, History and other AQT Files

By default AQT files are held at %APPDATA%\Advanced Query Tool. For Windows 7. 10 and 11 this will normally be C:\Users\<username>\AppData\Roaming\Advanced Query Tool\ however may be different depending on how your Windows system has been configured.

You may also have specified different directories for the AQT workfiles and queries. These are specified in Options > File Locations.

• copy these directories to the new machine
• if necessary, change Options > File Locations on the new machine to point to these directories

Copying your ODBC Datasource definitions

If you are using File DSNs, then you can simply copy the File DSN files to your new machine.

Otherwise there's no real way to do this - Microsoft provides no means to copy ODBC datasource settings between machines. The procedure described below is not recommended and may take more time to resolve problems than it will save.

The ODBC datasource definitions are held in the registry in the following places:

• (machine datasources)HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
• (user datasources)HKEY_CURRENT_USER\Software\ODBC\ODBC.INI

You can use Regedit export/import to copy these entries between machines. However be aware:

• there is no guarantee that this will work
• if your ODBC Drivers are installed into different locations, or have different names, these definitions will not work.

For some databases you will need to do some additional steps in addition to creating/copying the Datasource definitions. For example, for Oracle, you will need to set up tns_names.ora file with the connection info for the databases

Moving DB2 Connections

If you have some DB2 connections, you can migrate these to a new machine by using the db2cfexp and db2cfimp commands. These are run from a DB2 Command window.