1) Add ‘Oracle 10G’ as new DB Server in QC 9.x instances
2) Access QC 9.x Site Admin. Create a copy of the project to be migrated from QC 9.x instances, pointing that to the newly created Oracle server. After this step we will have a copy of the project connected to a Oracle server
Note: It is recommended to have same Domain Names in QC 9.x and QC 10 instances for the migration. Since the Database name will be created based on the domain selected, it will help in the smooth migration of the projects.
3) Copy over the repository of the project from QC 9.x location and to the repository location of QC 10
Note:
a) Creating a temp project in QC 10 domain will give us the repository location
b) If repository is copied from QC 9 ‘Migration’ Domain it is recommended to copy that to QC 10 ‘Migration’ Domain
4) Edit the dbid.xml file available in the QC 9.x repository location. Copy that over again to the QC 10 repository location (Click ‘yes’ on the alert message when it asks for override)
Note: This step is required while restoring the dbid.xml file from the QC 10 Client. Since QC 10 will open in a window for browsing, it can only browse from Windows location and not Linux location
5) Access QC 10 Site Admin. Select the Domain as Migration (Create the Domain if not available already) and click on Restore
6) Select the updated dbid.xml file from the location (refer step 4)
7) Click on Restore. The message will appear as Restored successfully.
8) Right click on the migrated project and say ‘Maintain Project> Verify’. Click on the button ‘Verify project’ in the window
Note: Since the project is migrated from SQL Server to Oracle, this task will show Schema differences. Additionally it will show any difference in the data which needs Repair
9) Right click on the migrated project and say ‘Maintain Project> Repair’
10) Right click to select ‘Maintain Project> Verify’ again. The Verify should be successful now
11) Right click to select ‘Maintain Project> Upgrade’. Click on Upgrade Project button in the resultant window
12) Once the Upgrade is Successful, Right click to Active the project.
13) Project is now ready for use in QC 10.
P.S. You can use the task sheet to make sure you follow all the steps.Download the task sheet here
