Migrating Qlik Sense from One Server to Another

QlikSense

Migrating Qlik Sense from One Server to Another

On original server

• In QMC, go to Certificates section and export new certificates using the FQDN of the new server.
• Be sure to include the Private key
• We need the certificates to be in the Windows format
• Record the UNC root path specified in the Service Cluster section in the QMC
• Stop all services except for the Qlik Sense Repository Database
• Create a new folder for the backup, e.g. C:\backup
• Open MMC and Export the Trusted Root Certificate used by Qlik Sense from the Local Computer / Computer Account snap-in. And place it into the backup folder
• Be sure to include the Private key
• Take a backup of the database (relevant help link)
• Sample command:

"C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\pg_dump.exe" -h localhost -p 4432 -U postgres -b -F t -f "c:\backup\QSR_backup.tar" QSR

• Copy all subfolders in the UNC root specified in the Service Cluster Section in the QMC to the backup folder
• Copy the Server certificate from the Exported Certificates folder to the backup folder (default: C:\ProgramData\Qlik\Sense\Repository\Exported Certificates)
• Optional:
• Zip the Backup folder for ease of transfer

New Server

• Install Qlik Sense of the same version
• During the installation process uncheck the check box to start services after installation. We will want to do extra configuration before Qlik Sense initializes
• Transfer the backup from the old server to local disk on the new server
• While the installer is working:
• Import the Trusted Root and Server certificate into the Local Computer / Computer Account snap-in section in their appropriate areas:
• Server > Personal
• Trusted Root > Trusted Root Certification Authorities
• Ensure that you mark the certificates as exportable
• Once the installation has finished, start the Qlik Sense Repository Database
• Restore the backed up copy of the database
• Sample command: "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\pg_restore.exe" -h localhost -p 4432 -U postgres -d QSR "c:\backup\QSR_backup.tar"
• If using a different share path for the Qlik Sense content
• Copy all subfolders from the UNC root specified in the Service Cluster Section in the QMC on the old server into a newly configured UNC path for the new server
• Open QlikSenseUtil
• Default path C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe
• Click Connect to database
• Enter superuser credentials
• Click OK
• Go to the Service cluster section
• Click OK to get the current values
• Make the appropriate edits
• Click Save
• To validate that the changes have been recorded:
• Click Clear
• Click OK

• To launch Qlik Sense with the new hostname:
• Open cmd.exe with administrative rights
• Change the directory to the Repository install path
• Default path C:\"Program Files"\Qlik\Sense\Repository
• Execute the following command: Repository.exe -standalone -restorehostname
• Allow the Repository.exe to run for a while
• Key log elements in C:\ProgramData\Qlik\Sense\Log\Repository\Trace\ > System_Repository
• Since no other services are running, a successful result from this restore command is the Repository to fully initialize but be unable to connect to the other services
• End the Repository.exe process in Task Manager
• Start all Qlik Sense services


Access the QMC and/or Hub to confirm that all previous working functionality is present