DB server migration

Below are the detailed steps to move the Database to another server.

You will need to:

1.     Update the siteadmin.xml file on the application server

2.     Modify the dbid.xml for all the projects.

Step 1. Updating the siteadmin.xml file on the application server

Note: Remember to make a backup of DB and Repository before any change. Also, move all the DB to the new DB server before perform the following steps.

For JBoss
1.Make a backup copy of the 20qcbin.war file found in the <QC_HOME>/application directory.

Linux/Unix:
mv -i 20qcbin.war sabin_bak.war

2. Move 20qcbin.war from <QC_HOME>/jboss/server/default/deploy to <QC_HOME>/application, and rename it to qcbin.war. This step will ensure all previous modifications are preserved.

Linux/Unix:
cp -i <QC_HOME>/application/jboss/server/default/deploy/20qcbin.war qcbin.war

3. Extract qcbin.war to a temporary directory (Ex. qcbin).

Example:
cd <QC_HOME>\application\20qcbin
jar xf <QC_HOME>\application\20qcbin.war

4. Open the siteadmin.xml file for editing (e.g., this file will be found at <QC_HOME>\application\20qcbin\WEB-INF).

5. Update the siteadmin.xml file using a text editor. Modify the <DbUrl>jdbc:mercury:sqlserver://qcsrv10:1433</DbUrl> with the correct information for the new DB server.

6. Zip up the qcbin.war file.

Example:

cd <QC_HOME>\application\qcbin
jar cvf qcbin.war *

7. Copy the qcbin.war file from <QC_HOME>\application\qcbin to <QC_HOME>\jboss\server\default\deploy.

Linux/Unix:
cp -i qcbin.war <QC_HOME>/jboss/server/default/deploy/qcbin.war

8. Rename the qcbin.war file to 20qcbin.war.

Linux/Unix:
mv -i qcbin.war 20qcbin.war

9. Restart the Quality Center service.

For Weblogic

Please refer to Document ID KM188675 - How to manually deploy or undeploy Quality Center Web application modules on WebLogic server

For WebSphere

Please refer to Document ID KM191173 - How to manually deploy or undeploy Quality Center web application modules on WebSphere server

Note:
Please refer to Document ID 186840 - How to start/stop the deployment of Quality Center on the application server for instructions on how to start/stop the deployment of Quality Center.

Notes:

·          <QC_HOME> is the installation directory of Quality Center.

·         The default location on Windows is C:\Program Files\Mercury Interactive\Quality Center.

·         The default location on Linux/Unix is /opt/Mercury_Interactive/Quality_Center/.

Step 2. Modify the dbid.xml for all the projects

You need to update all the dbid.xml files for all the projects to update the information about the new DB server.

1. Log into the Site Administrator.

2. Remove one of the projects.

3. Search for it dbid.xml file.

4. Edit the file:

* <DB_CONNSTR_FORMAT>jdbc:mercury:sqlserver://qcsrv10:1433</DB_CONNSTR_FORMAT> (Use the same as in the siteadmin.xml file)

* <DBSERVER_NAME>qcsrv10</DBSERVER_NAME>

* <PHYSICAL_DIRECTORY>C:\Quality Center\repository\qc\Domain\ProjectName\</PHYSICAL_DIRECTORY>

5. Save the file.

6. Return to Site Administrator.

7. Right click on the Domain and click on Restore.

8. Search for this dbid.xml file and click on Restore.

9. After the project is restored, click on Upgrade.

10. Activate the project.

11. Try to login to this project.

12. Repeat the steps from 1 to 11 for the rest of the projects.