How do you migrate ALM/QC from Oracle project database/schemas to SQL Server databases?
Question ID: 105954

We are currently on QC/ALM v11, with HPUX server and Oracle database.
We see that Windows Server 2008 R2 SP1 and SQL Server 2008 R2 SP2 database are supported/recommended for v12.2.

Since we will need to get off of HPUX anyway, we plan to use Windows Server 2008 R2 SP1 for our new AC/ALM12.20 load. Also, since our shop is going with SQL-Server instead of Oracle in other areas, we want to switch from Oracle to SQL-Server for our QC/ALM back-end.

How do you migrate from: QC/ALM v11 in Oracle to: QC/ALM v12.2 in SQL Server??
Specifically how to migrate from Oracle project database/schemas to SQL Server databases??

Marked as spam
Posted by (Questions: 193, Answers: 14)
Asked on February 24, 2015 10:14 pm
Answers (2)
Private answer

In your case, on your OLD server, FIRST add a DBSERVER to the dbservers tab pointing to a version of SQL-server that is supported by BOTH QC11 and QC12.x (SQL-SERVER 2008 R2/SP2 -- explicitly).
Then in your OLD server, make individual project COPIES where the resulting copy has a new/unique name AND you indicated SQL-Server as the target DB location.

When all of your projects are in SQL-Server, you can easily upgrade them as explained in the QC12.20 Installation/upgrade documentation..

As for the main QC database that keeps track of the users and list of projects (qcsiteadmin_db), there is NO easy way to convert that from ORA to SQL-server. so you must start over with that.

You can indicate to create a NEW one during 12.2 install, then when you RESTORE each project, it will add the users that were using that project into your ''global'' user list in Site admin -- but they will all have BLANK passwords and no email addresses or other user info.

Your project tree will also be empty -- you will need to re-create all domains (other than ''Default'') -- pay attention to the corresponding repository folder for the domain as when you migrate the project repositories they will need to be placed into the CORRECT/new domain folder and their respective DBID.XML files edited to reflect the NEW ''project directory'' path (you have to do this anyway as the old path was in Unix).

An alternative to all of this (keeping ORACLE) would be to make sure your ORACLE instance is one supported by ALM12.2 (you should probably migrate Schemas to a NEW instance separate from one used by QC11). You could install QC/ALM12.20 and indicate for it to UPGRADE a copy of the qcsiteadmin_db schema (this would keep the users and project tree). Then, all you would need to do is migrate the repositories to the Windows server location, edit DBID's and you can just RESTORE/VERIFY/REPAIR/UPGRADE the projects. -- NOW you would still be on ORACLE for the back-end - but your user/info would still be intact.

Marked as spam
Posted by (Questions: 4, Answers: 509)
Answered on February 24, 2015 10:20 pm
Private answer


I hope I can still get an reply on here. I tried to add the new MSSQL DBServer in the dbserver tab.
Will this create a new DB on the MSSQL Server (an instance is already running). Or do I need to do something else?
Because I get can ''Cant create DB'' error.
Maybe there is somebody here who can help me?

That would be great.


Marked as spam
Posted by (Questions: 0, Answers: 1)
Answered on October 14, 2015 1:05 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top