ChatGPT DEVChatGPT DEV

PractiProject

Migration

This page discusses the migration of Sprint Capacity Planning ang Tracking addon, to be used in Jira Cloud.

Pre- requisites

Jira data should be migrated before migrating plugin data, otherwise migration of some plugin data may be missed due to missing Jira information.

 

Migration of data

The best way to migrate large amounts of data is to migrate each project individually or in groups of multiple projects.

In order to understand in which projects the addon was used, you can find the ID of boards in the database for which teams were created.

To do this:

  1. Find the name of the table that contains data about the created teams:

select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME like '%ICONFIG_ENTITY%'
  1. Use the table name to find the id of the boards (e.g. 'AO_D4E654_ICONFIG_ENTITY'):

select distinct RAPID_VIEW from AO_D4E654_ICONFIG_ENTITY