I will assume that you are using Synchronized Persistence since it wasn't stated and 3.1.2 was the first build to introduce Shared Persistence.
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
- 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.3\bin\pg_dump.exe" -h localhost -p 4432 -U postgres -b -F t -f "c:\backup\QSR_backup.tar" QSR
- Copy the following folders to the backup folder:
- Apps folder (default: C:\ProgramData\Qlik\Sense\Apps)
- AppContent folder (default: C:\ProgramData\Qlik\Sense\Repository\AppContent)
- Content folder (default: C:\ProgramData\Qlik\Sense\Repository\Content)
- Extensions folder (default: C:\ProgramData\Qlik\Sense\Repository\Extensions)
- Optional:
- Log folder (default: C:\ProgramData\Qlik\Sense\Log)
- Archived Logs folder (default: C:\ProgramData\Qlik\Sense\Repository\ArchivedLogs)
- 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
- Copy the Apps into the apps path (default: C:\ProgramData\Qlik\Sense\Apps)
- If you placed the apps into a customized path on the old server, then be sure that path also exists on the new server and place the apps there
- Copy the Repository content into their needed paths
- 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.3\bin\pg_restore.exe" -h localhost -p 4432 -U postgres -d QSR "c:\backup\QSR_backup.tar"
- If restoring 3.1.x:
- Open up the Host.cfg file located at C:\ProgramData\Qlik\Sense\Host.cfg
- Decode the string from base64 (you could use a online decode generator, eg. search for decode base64)
- Open up pgAdmin3 (default: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin\pgAdmin3.exe)
- Click on the plug icon to create a new connection
- Set the Name as QSR
- Set the host as localhost
- Change the port to 4432
- Enter the superuser password
- Double click on the QSR Server connection
- Navigate: QSR > Database > QSR > Schemas > Public > Tables > LocalConfigs
- Hit Ctrl+D to view all rows of data on this table
- Scroll over to the HostName column and replace the old HostName with the newly decoded version for the new server
- Save the changes
- Start the Qlik Sense Repository Service
- We will expect it to find the imported certificates
- There will be activity in the Repository > Trace > Security log
- Stop the Qlik Sense Repository Service
- Start all Qlik Sense services
- Access the QMC and/or Hub to confirm that all previous working functionality is present
https://www.youtube.com/watch?v=neR22vySFH0
Migrating Qlik Sense 3 1 x - YouTube