how do I migrate the Agile data (Stories, themes, epics, and all associated tasks/activity records) from one Orlando instance to another?i

[Dennis7]

We need to carry forward the stories from one Orlando instance to a new instance.   For this, I assume we will also need the associated data, such as the themes, epics, sprint, tasks, activity, attachments, etc., so that when we work with the agile stories in the new instance, all the data associated with the stories is there.

Is there a utility for performing this?  What tables do we migrate? Is there documentation somewhere which describes the process?

Thank you in advance.

[JennyHu]

Hi Dennis,

I recently went through this and was wondering the same as well.  I couldn't find a utility and exported the data from each table manually to XMLs and imported them to the other instance.  We don't have data in all the tables, so I only exported wherever there's data. For a complete list of tables installed with Agile 2.0, see https://docs.servicenow.com/bundle/orlando-it-business-management/page/product/agile-development/ref...

Don't forget the data for agile group and group membership.

• sys_user_group (filter= type contains Agile Team)
• sys_user_grmember (filter = Group.type contains Agile Team)

The activities for the stories are included and I didn't have to do a separate export.  

If you use Project with Agile Development, you will also need to export data from Project tables such as:

• pm_project
• pm_project_task
• ... etc.

Hope this helps.

Jenny

[Rahul Priyadars]

I have used this UTILITY in past . Have a look and see.

https://developer.servicenow.com/connect.do#!/share/contents/9824957_add_to_update_set_utility?t=PRODUCT_DETAILS

Regards

RP