How do I install or upgrade AxioWorks SQList?

If you are installing for the first time:

After placing your order for SQList, you should have received one order confirmation email plus one or more licence emails (depending on the number of licences of SQList you ordered).

Installation procedure:

  1. Download the msi package from the Download SQList page;
  2. Run the installation package and follow the instructions.

This step will install both the AxioWorks SQList Windows service and the SQList Manager Windows UI application. A shortcut to the SQList Manager application will be added to your Start menu at Start/AxioWorks/AxioWorks SQList.

If you are upgrading to a newer version:

IMPORTANT, PLEASE READ: Although we always strive to make upgrades as hassle-free as possible, we strongly recommend that you test new versions on a test environment to avoid any surprises. We can send you a temporary SQList licence for this purpose, please contact support@axioworks.com if you would like to be sent one.

Upgrade procedure:

  1. Stop SQList Service;
  2. Stop any LOB system that may update the SQList destination databases;
  3. Take backup of all SQList destination databases;
  4. Take note of the version of SQList you are running (bottom-left corner of SQList Manager);
  5. Take a copy of the folder C:\ProgramData\AxioWorks\SQList;
  6. Take a copy of the following files from C:\Program Files\AxioWorks\SQList:
    - AxioWorks.SQList.ReplicationService.exe.config
    - AxioWorks.SQList.ManagerDesktop.exe.config
    - connections.config ;
  7. Un-install the current version of SQList;
  8. IMPORTANT: uninstalling SQList will:
    Leave your replication configurations and licence files in the installation folder (make sure you do not delete them);
    Remove the registered SQList Windows Services;
  9. Download and install the latest version of SQList from the Download SQList page;
  10. IMPORTANT: If you have made modifications to the configuration files (.config files listed in step 6 – e.g. you transferred the SQList Profile settings from SQL CE to SQL Server) in your previous installation, these modifications need to be re-applied to the same files C:\Program Files\AxioWorks\SQList;
  11. Launch SQList Manager;
  12. For major upgrades, install the upgrade licence (received by email);
  13. Start SQList Service, this step will re-register the SQList Windows Services with default settings (e.g. Manual Start-up mode);
  14. IMPORTANT: if you made changes to the settings of the SQList Windows Services in your previous installation (e.g. changed Start-up mode), these chagnes will have to be replicated to the newly registered services;
  15. Monitor logs and databases.

Roll-back procedure:

If anything goes wrong and you wish to roll back to your previous configuration:

  1. Stop SQList Service;
  2. Un-install SQList;
  3. Download and re-install previous version from the Download a previous version of SQList page.
  4. Restore folder C:\ProgramData\AxioWorks\SQList;
  5. Restore the files .config files from teh copies taken in step 6 above;
  6. If data have changed in destination databases: restore destination databases;
  7. Start SQList Service.

If you are unsure about any of the steps above or would like assistance with the upgrade, please contact our support team at support@axioworks.com.