Quality Center Project Migration

I just wanted to share my experience in migrating a project from QC9.2 to QC10

We have got a requirement from the user  to migrate QC9.2 project using SQL server 2005 as backend to QC10 Oracle. I had tried couple of options to migrate this and finally finalized the below process to complete this task. We even contacted the HP to know the best approach but unfortunately they don’t have process to accomplish this.

1)      We have created DB user (QC) on QC9.2  SQL server 2005.

2)      Added SQL Server DB server in QC10 server using DB servers Tab

3)      Created a project in QC10 using SQL Server 2005 DB server which was added in the previous step.

4)      Created a project in  QC9.2  by selecting make a copy of existing project.

5)      Removed project from site admin and Updated the db.xml file of the project which is created in step 2 with the project schema which is created step 4.

6)      Upgraded the project in QC10 by following steps (Verify, Repair and Upgrade).

7)       Exported the upgraded project to generate .qcp file.

8)      Imported the upgraded file by selecting Oracle as DB ( Migration from SQL server 2005 to Oracle was completed in this step by tool itself).

9)      Copied the attachments folder from QC9.2 NAS to Our QC10 NAS.