Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
tyagishaila
Specialist
Specialist

Qlik Sense migration to another server

Hello Community Members,

I am new to Qlik Sense,

My company wants to migrate Qlik Sense 2.2 (Currently using) from one server to another server (Windows Server 2016) with all apps, tokens, streams,user access etc. remain same.

Thanks in advance.

9 Replies
tyagishaila
Specialist
Specialist
Author

Please help me out.

arulsettu
Master III
Master III

arulsettu
Master III
Master III

Lauri
Specialist
Specialist

Shaila,

Did you determine that using the RSM was the best way to migrate?

Thanks.

tyagishaila
Specialist
Specialist
Author

No idea of this?

Lauri
Specialist
Specialist

Hi Shaila,

I was told that I have to do the setup manually on the new server. So I imported the apps from the old server, but I configured the streams, security, token allocation, virtual proxy, etc. manually.

Good luck,

Lauri

kevincase
Creator II
Creator II

Shaila,

In a nutshell, these are the steps you will need.  I have a single node installation so your process may be different depending on the complexity of your installation.  I would suggest creating a ticket with support to review any specific questions you may have.  You can find the procedure to backup and restore certificates in Qlik Help.

 

Download Qlik Sense Software to new server - same version 2.2 

On Existing Server

Run Cleanup script  

Stop all Qlik Services

Make a backup of the Repository database

Pg_dump.exe -h localhost -p 4432 -U postgres -b -F t -f "f:\QSR_backup.tar" QSR 

Backup certificates  - This is tricky if not keeping the same server name.

Trusted Root Certification Authorities (Local Computer)

Personal Certificates (Local Computer)

Personal Certificates (Current User) 

Backup log files

%ProgramData%\Qlik\Sense\Logs

Backup apps folder

%ProgramData%\Qlik\Sense\Apps

Backup supporting files (QVD, etc.)

QVD’s. Excel Files, etc.

%ProgramData%\Qlik\Sense\Repository\Content

%ProgramData%\Qlik\Sense\Repository\Extensions

Start Qlik services

On New Server

Install Qlik software (DO NOT START SERVICES after installation)

Repository Password: same as original server

Restore certificates

Start the Qlik Repository Database

Restore the database

Createdb -h localhost -p 4432 -U postgres -T template0 QSR

If DB already exists:  dropdb -h localhost -p 4432 -U postgres QSR

Pg_restore.exe -h localhost -p 4432 -U [postgres -d QSR "f:\QSR_backup.tar"

Restore Apps, Content and Extension folders – From original server

Restore Logs folder – From original server

Restore supporting files – from original server

Start Qlik services

Reset any connector passwords

Validate Sense Server license

Hope this helps.

Kevin ..

Not applicable

11rp1a0537
Contributor
Contributor

Hi,

We Moved QlikSense Server to Another New Server .We tried importing apps in QMC  in the new server then  the Reports are named in as  some Encrypted name.Can You Help me Out  in getting Apps names as normal names  that are in old server rather than  encrypted Name.Thanks in advance.

Regards,

Shruthi.