Quality Center Project Migration

If you want to migrate a project from one server to another you need to export the project schema in source server and import it in the target server. Export and import process depends on the backend which you are using. In addition to that you have to execute the below steps depending on the type of the db you using.

Steps for SQL Server:
Run the following SQL procedure on imported schema.
·  EXEC sp_change_users_login 'Report'
This unlinks the "td" user.
·  EXEC sp_change_users_login 'Update_One', 'td', 'td';
This links the "td" user of the TestDirector database to the same ID as the "td" user


Restore Process:(Common for both SQL and Oracle)
On the new Quality Center Site Administrator follow the next steps in order to restore the projects:
•Create a backup of the repository.

<Drive>:\Program Files\Mercury\Quality Center\repository\qc\<Domain>\<Project>\

•Create an empty project pointing to the new database server to compare the parameters of the dbid.xml file.

•Edit the parameters on the dbid.xml file as explained on the bellow image:

•Go to the QC Site Administrator and restore the project.
•Upgrade the project.