We have set up our two major divisions commercial and non-commercial on one QC project. Now Commercial wants to be seperated from non-commercial but they want all commercial data needs to be carried to new project. Please suggest us is there any approach to split project that can carry only commercial data.
Environment Details are QC Enterprise 11.0 Patch 14.
Database is on oracle 126.96.36.199 Operating system of app server Window Server 2008 R2 SP1 x64 bit JBOSS is the application Server. Current project schema size is 40GB Project Repository is at 600GB
Given the size of the project (based on the disk consumption you listed) I would say most methods that might be used for splitting the project are high risk. I think the least risky option is for you to make a full copy of the project for the Commercial group, and then begin deleting the non-Commercial data from that copy.
Any method of selectively copying data using the API or by directly manipulating the database is high-risk, in my opinion, because you may not correctly maintain relationships between different entities.
How much of the data in the project is just for the Commercial group? If it is only a small amount, it may not be such a high risk to try to selectively copy data.
If you want to try to selectively copy data from one project to another, your options are:
- do it by directly accessing the databases
- do it by using the OTA API to select the data, and then post it into a new project
- do it by opening the source project and in another window a new, empty project, and then through the UIs select items to copy from the source and paste them into the empty project.
Given the size of the project, you may also want to look into the Purge Results functionality and see if there is any data that you can get rid of.
[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.)
What is you main reason for this split? Is it because of too big project (slowness), maintainability or something else?
You need to move all the entities to a new project? So whole set of data related to non-commercial/commercial data? Including links between entities, attachments, favorites, etc? Did I get it right?
In this case I would consider project copy (full) and then delete unnecessary data. The problem is links between entities. Example if you have link Test Case-Test Instances-Runs-Defect, QC normal delete doesn’t work for all the use cases. But it would be much easier to make a tool for delete operations than whole copy. We have made a tool which allow you to move Test Lab data from one project to another. This is for archive purposes when your project size will grow too big.