Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle (1038 Views)
Reply
Advisor
DiegoColombatto
Posts: 25
Registered: ‎05-24-2011
Message 1 of 12 (1,286 Views)
Accepted Solution

how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

Hello I've:
- one installation of QC 10 based on SQL server 2005
- one installation of ALM 11 based on Oracle 10.2.0.4

 

Is it possible to connect ALM11 to sql server 2005 (qc 10 db) and copy/upgrade projects to Oracle 10.2.0.4 ?

 

The objective is to have in ALM 11:

- all projects created by users (in ALM 11)  before starting this activity
- all QC 10 projects (upgraded to ALM 11 version)

 

thanks and kind regards,
Diego

Please use plain text.
Respected Contributor
Andrey_L
Posts: 206
Registered: ‎04-02-2012
Message 2 of 12 (1,273 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

Hi,
As i know there is a way to convert MS SQL db to Oracle

But as for me you can use simple way:
1. Connect MS SQL db to your ALM 11 server
2. Restore/upgrade projects from QC10 to ALM11
3. Copy projects, using appropriate ALM feature and on db step select your Oracle server

Please use plain text.
Trusted Contributor
leobor
Posts: 195
Registered: ‎07-08-2009
Message 3 of 12 (1,265 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

You may also want to take a look at these articles describing transition from one database server to another:

MS SQL Server to Oracle: http://www.oracle.com/technetwork/database/migration/sqlserver-095136.html
Oracle to MS SQL Server: http://www.microsoft.com/en-us/download/details.aspx?id=24662
Please use plain text.
Honored Contributor
shiv_p
Posts: 2,833
Registered: ‎04-23-2008
Message 4 of 12 (1,254 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

Although such migration could not be supported by ALM support it may be helpful to know the options.

There is a migration tool released by Microsoft

The tool is located here http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle
Please use plain text.
Advisor
DiegoColombatto
Posts: 25
Registered: ‎05-24-2011
Message 5 of 12 (1,251 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

Hi Andrey,

 

2. This is done using GUI and basically is operating only on QC 10 db, am I right?

Once this operation is completed I can no longer use migrated projects from QC 10, right?

 

3. Which feature do you refer to? Is it possible (using GUI) to copy one (ALM 11) project from SQL db to oracle db?
Shouldn't I also copy project directory from QC 10 server to ALM 11 server?

 

Thanks and kind regards,
Diego

Please use plain text.
Respected Contributor
Andrey_L
Posts: 206
Registered: ‎04-02-2012
Message 6 of 12 (1,238 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

Hi,

Yeas all operation that i propose to do - it's GUI operation

You can use project on QC 10 if you create copy of project db and project rep.

more information how to restore project you can find in QC documentation

All that i propose to use its QC features

and 'migration' from MS SQL to Orecle will be performed on ALM 11 using copy project feature

Please use plain text.
Advisor
DiegoColombatto
Posts: 25
Registered: ‎05-24-2011
Message 7 of 12 (1,184 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

Hello, I've a concern about QC 10 users.

 

With the steps suggested above, I'm going to migrate projects from qc 10 to alm 11, but this process is going to migrate also users associated to projects?

If not, how should I proceed to move qc 10 users into alm 11?

 

thanks and kind regards,

Diego

Please use plain text.
Respected Contributor
Andrey_L
Posts: 206
Registered: ‎04-02-2012
Message 8 of 12 (1,179 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

When you restor project all users that were asosiated with project should be automaticaly imported to SA schema

 

But user details and pusswords will be empty

 

any way if you use LDAP you can reimport users

Please use plain text.
Advisor
DiegoColombatto
Posts: 25
Registered: ‎05-24-2011
Message 9 of 12 (1,177 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

Unfortunately users were not imported via ldap, so I cannot reimport them.

 

Is there a way to add user details and passwords (other than adding them manually) ?

 

thanks and kind regards,

Diego

Please use plain text.
Honored Contributor
Trudy Claspill
Posts: 3,391
Registered: ‎09-09-2010
Message 10 of 12 (1,167 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

@Diego

You could, possibly, use the Site Admin API (compatible with the QC version on your source system) to extract the user details from the source system, and then use the Site Admin API (compatible with the ALM version on your destination system) to add those details to the destination system.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
Please use plain text.
Respected Contributor
Andrey_L
Posts: 206
Registered: ‎04-02-2012
Message 11 of 12 (1,163 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

[ Edited ]

Hi,


You can try to copy (export) data from USERS in old sa schema and import them to the new


also (as i remember) you need to update appropriate sequence (USER_SEQ must be equal to the maximum value in USER_ID column)

Please use plain text.
Advisor
DiegoColombatto
Posts: 25
Registered: ‎05-24-2011
Message 12 of 12 (1,038 Views)

Re: how to migrate from QC 10 on SQL Server to ALM 11 on Oracle

In the end I proceeded with Andrey_L solution and it was a success.

 

Just in case someone want to try it, be aware that users are recreated with just username and password (no other details) when you import project in alm 11.
This was not an issue for us because alm was configured to authenticate users using LDAP and after the first login alm user details are populated with LDAP user details (mail, phone, description,...)

 

I did not try solution based on third party tools to migrate database, because if something goes wrong you're on your own to solve the issue.

 

thanks and kind regards,
Diego

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation