What is best method to export users from Oracle based QC to SQL based QC?
Question ID: 105253

Our old Quality Center server is version 10. Our new one is version 11.52. The QC10 version is Oracle DB based, while the new 11.52 is SQL based.

To add we went with a new qcsiteadmin schema for the QC11.52 server. Also adding to the mix is that our users from QC10 are LDAP imported users.

We migrated our projects over and in doing so the user IDs were populated. However the other user information such as email addresses, phone numbers, and the like did not get imported along with the user IDs.

Question is for the best method to export the other user information out of QC10 Oracle DB and import to QC11.52 SQL Server?

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on January 31, 2014 2:41 pm
Answers (1)
Private answer

This is what an HP Engineer suggested as the best practice method for doing such an information move between Oracle and SQL tables, when a new site admin schema has been created during the install of a second QC server.

--Assumption: Created a new site admin schema on SQL server during the installation

1) Restore the projects into the ALM Server (You will see the user_id on the new site admin schema)

2) Export the Users table from the Oracle server to a text plain

3) Import the text plain that has the information of the user to the SQL server

4) Do an update SQL command.

It could be something like this:

update td.users
From dbo.export_users a

Be sure to open the Site admin schema and add the columns from the user table to this query to get all necessary fields that you require.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on January 31, 2014 2:46 pm

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

Scroll to Top