Page Comparison

As Atlassian has stepped up its Cloud game, lot of teams are moving from Jira Server/DC variants to Cloud. To support this transition, UpRaise apps let you take your existing UpRaise data from Server/DC and move it to Cloud. This can be done via JCMA tool provided by Atlassian or via manual steps. Reach out to us on our service desk so that we can offer our guidance for UpRaise apps migration.

Following steps need to be run while migrating from on-prem to cloud manually.

Exporting UpRaise data from on-prem

As far as export of current data is concerned, please upgrade your on-prem UpRaise app to the latest version & then follow these steps:

• Hit the URL based on which app you are using

  • Employee Success - <jira-server-domain>/rest/upraisesuccess/latest/upraise-migration/export-data

  • Employee Garrison - <jira-server-domain>/rest/upraise/latest/upraise-migration/export-data

  • People - <jira-server-domain>/rest/upraisepeople/latest/upraise-migration/export-data

• Exported data will be available at location <jira-app-data-dir>/upraise/export/xxxx-xxx-xx-xxxxx.zip

Jira data mapping

In addition to the UpRaise export data coming out of above endpoint, we need mapping between Jira entities from on-prem to cloud. Details laid out below (old refers to datapoint from Server/DC, new refers to datapoint from Cloud)

• User

  • old - userKey, new - accountId

• Project

  • old - projectId, new - projectId

• Issue

  • old - issueKey, new issueKey

  • old - issueId, new issueId

• User groups

  • old - groupName, new - groupName

• Custom fields (if used in OKR configurations to calculate progress)

  • old - customFieldId, new - customFieldId

• We need the data in json format as below (if issueKeys remain same then that can be ignored)
  {
  "users": {
  "username1": "accountid1",
  "username2": "accountid2",
  },
  "issueIds": {
  "10001": "10100",
  "10002": "10200"
  },
  "issueKeys": {
  "UP-100": "UP-1000",
  "UP-200": "UP-2000"
  },
  "projectIds": {
  "10200": "20200",
  "10300": "20300"
  },
  "groups": {
  "developers": "new-developers",
  "product-owners": "new-product-owners"
  },
  "customFields": {
  "customfield_10006": "customfield_10006"
  "customfield_10007": "customfield_10007"
  }
  }

Finding our UpRaise - Jira links

You need to run below queries on your Jira database (on-prem instance) to find out UpRaise - Jira links. Please share this information with us on the migration support ticket you created on our support portal. Do note that the syntax could change based on your database.

//Query to find out which Jira issues are linked to feedback. Here RESOURCE_ID is a Jira issue key.
SELECT DISTINCT "RESOURCE_ID" FROM "AO_EB0AB3_UP_FB" WHERE "RESOURCE_TYPE"='ISSUE';

//Query to find out which Jira issues are linked to the feedback requests. Here RESOURCE_ID is a Jira issue key.
SELECT DISTINCT "RESOURCE_ID" FROM "AO_EB0AB3_UP_FB_REQUESTS" WHERE "RESOURCE_TYPE"='ISSUE';

//Query to find out which Jira issues are linked to the issue as a key result. Here TITLE is a Jira issue key & ISSUE_ID //is a Jira issue id.
SELECT DISTINCT "TITLE", "ISSUE_ID" FROM "AO_EB0AB3_UP_OBJ_KEY_RESULTS" WHERE "OKR_TYPE"=2;

`//Query to find out which JQL is linked to JQL as a key result. Here ISSUE_DETAILS is a JQL.
SELECT DISTINCT "ISSUE_DETAILS" FROM "AO_EB0AB3_UP_OBJ_KEY_RESULTS" WHERE "OKR_TYPE"=3;

//Query to find out which Jira issues are linked to issue as a key result action. Here TITLE is a Jira issue key & //ISSUE_ID is a Jira issue id.
SELECT DISTINCT "TITLE", "ISSUE_ID" FROM "AO_EB0AB3_UP_OBJ_KR_ACTIONS" WHERE "ACTION_TYPE"=0;

//Query to find out which JQL is linked to JQL as a key result action. Here ISSUE_DETAILS is a JQL.
SELECT DISTINCT "ISSUE_DETAILS" FROM "AO_EB0AB3_UP_OBJ_KR_ACTIONS" WHERE "ACTION_TYPE"=1;

//Query to find out which Jira fields are linked to auto update metric key result configuration. Here FIELD is a Jira //field name.
SELECT DISTINCT "FIELD" FROM "AO_EB0AB3_UP_OBJ_KR_PRG_CNF" WHERE "AGGR_FUNCTION" IN (2,3);

//Query to find out which JQL is linked to auto-update metric key result configuration. Here JQL is a JQL.
SELECT DISTINCT "JQL" FROM "AO_EB0AB3_UP_OBJ_KR_PRG_CNF";

//Query to find out which Jira projects are associated with the project restrictions issue panel.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='issue_panel_enabled_exceptions';

//Query to find out which Jira projects are associated with the project restrictions feedback panel.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='cf_enabled_exceptions';

//Query to find out which Jira projects are associated with project restrictions OKR panel.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='okr_enabled_exceptions';

//Query to find out which Jira groups are associated with Jira group-based access setting.
SELECT "VALUE" FROM "AO_EB0AB3_UP_SETTINGS" WHERE "KEY"='GROUP_ACCESS_EXCEPTIONS';

//Query to find out which Jira groups are associated with UpRaise team.
//Here JIRA_GROUPS are stored in an encrypted format.
SELECT DISTINCT "JIRA_GROUPS" FROM "AO_EB0AB3_UP_TEAMS";

Sharing the data with us

You will need to upload the exported zip file and the json to a Dropbox link we share with you. Post that we will import this data on the cloud instance (please share this url with us on the ticket) where you can verify it.