Migration of Qlik Sense from existing Windows 2008 server to AWS Cloud Services

[hbandari3636]

Can any one share the steps required in migrating existing Qlik Sense running on Windows 2008 Server to AWS Cloud please?

Appreciate your help in advance.

Thanks,

Hemantha.

mto Qlik Sense Forums‌

[simon_minifie]

Hi There,

This will be a backup and restore process.

1. Backup the repository and share in your current server.
2. Create AWS instance and install Sense
3. Restore the backup and share to the AWS instance

Instructions can be found here:

https://help.qlik.com/en-US/sense/April2018/Subsystems/PlanningQlikSenseDeployments/Content/Deployme...

Thanks,

Simon

[Levi_Turner]

What version of Qlik Sense? What persistence model is in use?

[hbandari3636]

Version is 3.1 SR2 and currently its on single node (central node). Main concern about this is we have performed a silent installation of the setup and there is no password we have set for repository database.

[Levi_Turner · Accepted solution]

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

[Anonymous]

Is the process the same when you want to move from AWS to On-prem ?

[hbandari3636]

Thank you This was very helpful to go through...

[alis2063]

Hi Sir,

Do you have documentation for the same??

Regards,

Ali