Migrate or change iQSonar database connection

Owned by Former user (Deleted)
Last updated: Aug 31, 2018

The following guide lays out a step-by-step procedure to migrate the scan-engine to use a different back-end database connection, either because the DB is being migrated to a new host or because the connection credentials are being changed..

Please note that it is not recommended to migrate the database to a new server and upgrade between versions of iQSonar in one step. If you need to upgrade the ScanEngine version, please do that as a different procedure. 

Migrate a single-scan-engine installation

To migrate a single-scan-engine configuration to use a database on a new server, or when you are changing the credentials used to by the scan engine to access the DB:

  1. Pause all active projects, and wait until the server is idle
  2. stop the iQSonar ScanEngine service
  3. Back up the iQSonarSE database from the old server/location
  4. Restore the iQSonarSE database to the new server if this is different from the old location.
  5. Make a backup of your iqsonar.key file, and your iQuate.iQSonar.ScanEngine.exe.config files. These are found in the folder "C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin" in a default installation.
  6. Uninstall iQSonar, and then delete the folder “C:\Program Files\iQuate\iQSonar ScanEngine 4.0\”
  7. Install the new version of iQSonar using a “custom” install, but make sure you do not allow it to start the service. When prompted for the iqsonar.key, point to the location of the key you backed up in step 5
  8. Restore the copy of iQuate.iQSonar.ScanEngine.exe.config to the C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin folder.
  9. ONLY NOW can you start the service.
  10. Once the service has started, you can log in to the UI and unpause the project.

Migrate a multiple-scan-engine installation

  1. Pause all active projects, and wait until the server is idle
  2. Stop the iQSonar ScanEngine service on all servers
  3. Back up the iQSonarSE database from the old server
  4. Restore the iQSonarSE database to the new server if you are migrating the DB to a new location.
  5. We will upgrade the scan engine server which hosts the User Interface first.
    1. Make a backup of your iqsonar.key file, and your iQuate.iQSonar.ScanEngine.exe.config files. These are found in the folder "C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin" in a default installation.
    2. Uninstall iQSonar, and then delete the folder “C:\Program Files\iQuate\iQSonar ScanEngine 4.0\”
    3. Install the new version of iQSonar using a “custom” install, but make sure you do not allow it to start the service. When prompted for the iqsonar.key, point to the location of the key you backed up in step 5. Ensure you have the correct database settings for the new database location/credentials.
    4. Restore the copy of iQuate.iQSonar.ScanEngine.exe.config to the C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin folder.
  1. Restart the service on the UI server. This should upgrade the DB.
  2. Wait until the DB has finished upgrading and the version-number shown for the scan-engine in the UI is correct.
  3. Repeat step 5 a – d for all other scan engines, without starting the service on the servers.
  4. Once all the scan-engines have been migrated, THEN you can restart the service on all the servers.
  5. Now you can unpause any projects which were paused in step one.