I had to migrate some projects from a Jira instance with Jira Agile to a new instance, which has exactly the same configuration. The source instance has some more data and I need to move such data to the new instance without restoring the entire backup.
I know that when importing projects, sprints and ranking are lost and now I need to manually restore them.
So, customfield table has its entry "Sprint" (id=10212), which is referred from table customfieldvalue with several entries of the type
(issue, 10212, stringvalue).
Issue clearly refers to the issue id (i.e. story id), while
stringvalue, for custom field with id
10212, refers to the sprint id. In fact, in table
AO_60DB71_SPRINT, ids are the same as
Also, I can see that sprints listed in
AO_60DB71_SPRINT are correctly connected to their respective boards in
Finally, I copied the content of
AO_60DB71_ISSUERANKING from source to destination instance.
So, the roundtrip seems to be fine, but my issues are not correctly distributed across sprints.
What am I missing?
Including your JIRA & (most importantly) JIRA Agile version would be needed to really answer your question but I think the first place to look would be your customfieldvalue table. However, to hazard a guess the locked 'Sprint' custom field data which ties an issue to a sprint (again, only in more recent versions of JIRA Agile) is not migrated/imported by JIRA Project Import. To get the issues to appear in their proper sprints you need to 'manually' migrate those records - which is a pita, but essentially fairly easy - just remember to adjust the sequence_value_item.seq_id value (where seq_name = 'CustomFieldValue') to a higher value than the max(target.customfieldvalue.id) + count(source.customfieldvalue) records for source.customfieldvalue.customfield=10212 (in your case).
You also didn't mention how you migrated rapid boards or how you migrated your source.AO_60DB71_SPRINT data (which references the rapid board as you say in your question) - doing this incorrectly would hose the target systems ability to properly display sprint data.
Yes, the migration was successful in merging the sprint history, open and future sprint information along with the ranking data. The ranking data was the easiest - just had to remove the records that were created by the indexer or something because we had JIRA Agile enabled during the project import phase and it (I'm guessing) had created a rank record for every issue it thought needed to be ranked. I don't have time now to go into greater detail but yet I'm open to sharing what we learned as time and interest allow. I won't be able to post the exact SQL, and so on, but I can provide some parts of the writeups we did to manage the process. -wc
My migration was not successful in terms of allocation of stories to board columns, but I did map issues to their corresponding boards. However, I really cannot remember the exact sequence of steps and queries; I do remember that William's answer actually addressed my main issue.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot