Server/DC to Cloud migration

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.

You need to export the upraise data to a file and share exported file with us. We will import it manually. There are 2 ways to export data

Option 1: Export and map data manually

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"
    }
    }

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.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 //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.

 

Option 2: Export data using JCMA tool

While migrating Jira using migration assistant, choose Upraise app as well to migrate. Please note, this will not migrate upraise app data to cloud, it will export data automatically with proper mapping in json file in zip and you do not need to create this json file manually as mentioned in Option 1.

Once migration status becomes Complete, exported upraise data can be found at “<jira-app-data-dir>/upraise/export/xxxx-xxx-xx-xxxxx.zip”

You will need to upload the exported zip file 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.