@kumarbala - data connections in the QMC will be there after you restore the site. You'll probably need to edit the connections to ODBC sources since the drivers may be different (I had that experience with an Excel connection; the spelling is slightly different on Windows Server 2022 than a prior version).
Tip: Don't delete any Qlik users before or after migrating unless you are certain those users don't own anything in Qlik, including streams, connections, apps, etc. Streams and connections disappeared for me when I deleted a very old user account that owned them.
The community article Chetan provided is missing a little info:
Step 13 needs steps after b:
- If a new share path is going to be used then:
- Open QlikSenseUtil.exe (default location C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\)
- Click Connect to database and enter valid credentials for the postrgres or qliksenserepository user
- Click "Service cluster" and "OK"
- Update the network paths to the shared folders
Also, have this discussion handy; I had to apply the SQL query to all four DBs in my new postgres immediately after restoring them.
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Repository-won-t-start-Inactive-l...
DO
$$
DECLARE
row record;
BEGIN
FOR row IN SELECT tablename FROM pg_tables WHERE schemaname = 'public'
LOOP
EXECUTE 'ALTER TABLE public.' || quote_ident(row.tablename) || ' OWNER TO qliksenserepository;';
END LOOP;
END;
$$;
Lastly, these two commands can be your good friends when trying to restore the site with the command line restore:
.\dropdb.exe -h localhost -p 4432 -U postgres QSR
.\createdb.exe -h localhost -p 4432 -U postgres -T template0 QSR
Replace "QSR" with any of the other 3 database names. This is handy if Qlik started the services after you install the software, which creates the empty databases. You can't restore if they already exist, so drop and create the empty templates, then run restore.
