How do we know we are migrating the correct qcsiteadmin_db to the new server?

  • Questions
  • How do we know we are migrating the correct qcsiteadmin_db to the new server?
Question ID: 107726
0
0

WE are upgrading from QC11.52 to 12.53 and have a series of qcsiteadmin_db variations in our OLD database.

How do we know that we are migrating and upgrading the right one?

Marked as spam
Posted by (Questions: 176, Answers: 12)
Asked on July 18, 2017 5:54 pm
3 views
Answers
0
Private answer

This is the Default 11.52 Deploy folder:
C:ProgramDataHPALMwebappsqcbin

In the WEB-INF folder, look for ''siteadmin.xml''

Open Siteadmin.xml (with Internet Explorer) to see location and name of ''siteadmin'' database - usually called ''qcsiteadmin_db'' or similar variation.

![alt text][1]

Here, we have ''qcsiteadmin'' (DbName) on SQL-server ''localhost:1433 (DbURL).
Also notice the encrypted password and initialization strings, these are generated based on the Confidential Security passphrases - the phrases must be the same for the NEW server as were on the OLD server or this qcsiteadmin_db cannot be used.

[1]: /storage/temp/633-siteadmin-img.png

Marked as spam
Posted by (Questions: 3, Answers: 448)
Answered on July 18, 2017 5:58 pm