Skip to main content

Migrating Qlik Sense Enterprise Like a Boss

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Migrating Qlik Sense Enterprise Like a Boss

Last Update:

Oct 13, 2023 5:20:51 AM

Updated By:

Troy_Raney

Created date:

Jul 23, 2021 7:55:37 AM

In this Webinar, we covered how to approach a Qlik Sense Enterprise on Windows migration.

The session covers:

  • How to Back-Up and Restore
  • Managing Certificates
  • Potential Pitfalls
  • Automation Options
  • If assistance is needed, Qlik Consulting would need to be engaged. Qlik Support cannot provide walk-through assistance with server migrations outside of a post-installation and migration completion break/fix scenario.

 

 

Resources and Related Content:


Qlik Sense Migration: Migrating your Entire Qlik Sense Environment (Blog post)
Help.Qlik.Com Documentation: Backup and Restore Qlik Sense Enterprise on Windows
Qlik Sense Upgrade Guide
Qlik Admin Playbook

 

Q&A:

Q: Is it possible to migrate from a standalone installation to a clustered one? 
A: Yes. Once the Central Node has been moved to a new host, additional Rim nodes can be added as usual through the QMC. 

Q: What about the personnal objects created by users (sheets, bookmarks, ...) ?  Are they included in the QSR backup ? 
A: All user objects as well as base sheets are included both in the Apps themselves as well as in the QSR. 

Q: Is this possible to migrate one repository to another server and merge the repository with another one? 
A: Not through the procedure outlined in this webinar. If your goal is to merge content from multiple sites, or seamlessly migrate content, I recommend reaching out to your Account Manager and discuss Qlik Mission Control platform. 

Q: Would the steps given here change if postgres is installed on a stand-alone server?
A: The only steps that would change would be the backup/restore for the DB itself, as this would have to be performed locally on the DB host. Additionally, if the DB location has changed, the QRS connection strings will have to be updated via QlikSenseUtil. 

Q: Is it necessary to have the same release on both servers before migrating ? Or is there compatibility between versions of QlikSense ? 
A: You can restore a database from a previous version on a newer Qlik Sense release and the system will update the internal objects automatically, however the reverse is not possible. It is recommended to perform the upgrade in place, before migrating the server. 

Q: Is it possible to restore without certificate ? 
A: Yes, Trust Root and Qlik Client certificates can be recreated from scratch, however as mentioned during the call, all internal metadata values that were previously encrypted, such as data source connection strings, would have be updated via the QMC by re-entering the connection password and saving. 

Labels (3)
Comments
raj_qlik9
Contributor
Contributor

@Sonja_Bauernfeind 

Need your input please 

We have two isolated different Qliksense environments, both are single node servers only.

Env1 and Env2,  now we want to combine both environment to one single Environment lets call Env3 so we don't have the burden of maintaining two different environments.

Could you please suggest us how to do it ?

 

Thanks

Raj

 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @raj_qlik9 

Combining these would mean migrating over apps and other customisations from one environment to the other as you cannot migrate one environment "ontop" of another one as it would simply overwrite the other one.

If you require direct assistance to do so, I would recommend getting in touch with our Consulting Services.

Though you are more than welcome to post about your query in our Deployment forums as well to see if other Qlik Sense administrators have previously done something similar as what you are looking to do.

All the best,
Sonja 

snibrahim1993
Partner - Contributor III
Partner - Contributor III

@Sonja_Bauernfeind  Is the above migration on the same server or a different server?

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @snibrahim1993 

This is for moving hosts (so, a different server). Migration indicates a movement from and to. 

All the best,
Sonja 

Skage
Partner - Contributor III
Partner - Contributor III

Hi @Sonja_Bauernfeind 

I'm preparing for a bunch of migrations and there's one thing I don't get...

In the video Mario is exporting two sets of certs:

  1. via QMC to a folder named SenseServer2.domain.local
  2. via the mmc exports to a folder named SenseServer1.domain.local

He is saying that the mmc-exports in the SenseServer1-folder are purely for "safe keeping" and the certs to transfer and import in the new machine are the QMC-export certs located in the SenseServer2.domain.local folder.

The weird thing is that he is importing certs from the SenseServer1.domain.local folder on the new machine.

Skage_0-1696514433848.png

 

So what is correct?

What he is saying or what he is doing? Or was the folders renamed before importing?

Is it a mistake that would explain why SenseServer1.domain.local is referenced in both columns for the CA-cert on the new machine? Shouldn't this be SenseServer2.domain.local in the first column or is that not important? 

Skage_1-1696514958039.png

The August 2023 documentation is exporting everything via mmc and restoring those on the new machine.

Are the two sets identical or is the act of setting the fqdn in the QMC-export important?

TIA!

/lars

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Skage 

I am reaching out to Mario to get clarification.

All the best,
Sonja 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @Skage 

After a chat with Mario, here's the clarification:

Exporting the certificates with the correct new name from the QMC is the preferred method, as this makes things easier to manage once the original server has been decommissioned or replaced. Though both methods are correct.

In the video, the certificates were imported from the "wrong" folder - though technically not wrong, as either work OK.

We'll work on having the mismatch of voiceover and visuals in the video clarified.

All the best,
Sonja

Skage
Partner - Contributor III
Partner - Contributor III

Hi @Sonja_Bauernfeind 

Thank you for clearing things out for me.  I just needed to have it confirmed before I attempt a migration. Good to know that both ways would work but one would hurt the eyes a bit 😄 

All the best to both you and Mario!

 /lars

mikegrattan
Creator III
Creator III

What about license keys?  When I install Qlik on my new server do I use the same signed license key that is on my old server?  

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @mikegrattan 

Correct, you would be using the same license. As for parallel use, I would recommend reaching out to your account manager to verify what your license is entitled to, but a signed license key can be used across sites, synchronizing users. See Qlik Licensing Service Reference Guide

All the best,
Sonja 

Version history
Last update:
‎2023-10-13 05:20 AM
Updated by: