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

« Back

Tags:

Question ID: 107726

▲

▼

♥ 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 gobroncos (Questions: 193, Answers: 14)

Asked on July 18, 2017 5:54 pm

27 views

Answers (1)

▲

▼

✔

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