When a customer needs to change the iQSonar database settings (either because they are changing the connection credentials, or because they are migrating the DB to a different server instance) there is currently no simple method to change the settings in the User Interface.
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..
| Note |
|---|
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
...
- Pause all active projects, and wait until the server is idle
- stop the iQSonar ScanEngine service
- Back up the iQSonarSE database from the old server/location
- Restore the iQSonarSE database to the new server if this is different from the old location.
- 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.
- Uninstall iQSonar, and then delete the folder “C:\Program Files\iQuate\iQSonar ScanEngine 4.0\”
- 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
- Restore the copy of iQuate.iQSonar.ScanEngine.exe.config to the C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin folder.
- ONLY NOW can you start the service.
- Once the service has started, you can log in to the UI and unpause the project.
...