Data Migration Utility
![]() We are trying to migrate the data from one project area to another project area where we want to copy all the work items and all the attributes of the work items in destination Project Area. We have a source Project Area which contains ADT Peer Review Work item and ADT Action Item. But in the destination Project Area we do not have any Peer Review Work item and ADT Action Item so we will be migrating the data in ADT Task Work item in destination Project Area. This can be achieved by using the functionality of "Move or Copy this work item in another project Area". We also want the mapping between the two work items where we can map the attributes from source and destination. Eg: Source A Project area contain an attribute named as "Contact Name" but in Source B (the destination Proejct Area) we do not have that attribute, instead we would like to map that attribute with the target Project area attribute. Because it does not copy the attribute values when we try to use the functionality "Move or copy this work item in another Project Area" when they have different naming conventions in Source and destination project area.
We are trying to build a java custom utility where there will be mapping in the excel sheet which will transfer the values of the attributes from source to destination Project area. My question here is do we have any alternative method for this? Do anyone have this custom utility already developed or anyone who can help me up with the best possible approach?. It would be really helpful. Thanks, Kapil |
4 answers
![]()
Hi Kapil,
Before Data migration, the skeleton of two projects should be identical .i.e. the attributes in target should be in consistency with that of target project area. However, requirements can get peculiar. If you insist that target project area cannot be in consistent with that of source, you can do the following. 1. Export workitems from source project area with their desired attributes to a .csv file. 2. Please change the attribute names present as column header in obtained csv to the desired attribute names of destination project area. 3. Now try importing the csv file in destination project area. 4. Please be informed that it will create new workitem in destination Project area. Hope it helps. |
![]() Thanks for the quick response Ajay. Exporting the work items from souce project area and changing the attribute names one by one would be time consuming as a source project area may contain thousands of work items and changing the attribute names would be very tedious.
Do we have a custom utility where I can save my time wherein at a go it will move all the attribute values in destination project area or any other functionality which can help?
Thanks again. |
![]() Susan,
Can you please help me with your utility or the RTC Java APIs it would be really helpful for us as we are wroking on the same repository. Thanks in advance |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
you should be able to create a mapping file for the csv import to map the contet where-ever you want to.. same field, or different.
we did that when we migrated a team from 3.0.1 to 4.0.3
export, create the mapping file, fixup a couple columns of data (users mostly) and then import into new project.
some things don't copy easily.. links, attachments, approvals, comments.
or they copy but reference old data..