Syncing Jira Data Between Instances

Question

Hi everyone,

I’m currently facing a challenge where two areas within our company are using different Jira instances — one on Jira Data Center and the other on Jira Cloud.

Due to a project my team is working on, I’m required to manually duplicate all the information from one Jira to the other (including tickets, points, and statuses). As you can imagine, this is not only time-consuming but also quite unmotivating.

Since the project is already well underway, changing our workflows isn’t really an option and we also don't want to use Exalate or others.

I’ve heard about bulk exports and imports as a potential solution, but I’m not sure if this will work in our case.

I’d appreciate any advice or suggestions on how to streamline this process.

Thanks in advance for your help!

Mathieu Lepoutre _Exalate_ · Answer

Hello @Joao Resende

I work for Exalate

Dealing with two separate Jira instances can indeed be a logistical headache. Exalate is specifically designed to sync data across Jira instances without overhauling your workflows. For instance seamless synchronization between Jira Cloud and Jira Data Center, maintaining ticket details, statuses, and more in real time. I know you mentioned not wanting to use Exalate or similar tools, but it might be worth reconsidering, given your project's demands and the manual effort involved.

Thank you.

Kind regards,
Mathieu Lepoutre

Matthias Gaiser _K15t_ · Answer

Hey @Joao Resende

if you want to give exporting and importing with csv a try, these documentation links might come in handy:

* How to export issues from Jira cloud in CSV format
* Import data from a CSV file

I'd recommend trying out this approach in a test project with only the fields you need to update.

If you're searching for a more automated solution, you could try building some Jira automations which react to Issue Updated/Created events and then use the Jira REST API (Data Center / Cloud) of the other Jira to update the corresponding issue.

Alternatively, if you're familiar with scripting, you could also write yourself a shell/python script (or similar) which gets all issues from one Jira and updates them on the other Jira via the Jira REST API.

If these solutions are all too technical for you, I think it comes back to what you said you didn't want: an issue sync app. I'm part of the team behind Backbone Issue Sync where we concentrate on making issue syncing as simple as possible - you configure some rules and get your issues synchronized automatically.

These are all approaches I can think of. I hope this helps you a bit.

Cheers,
Matthias.

Lucas Modzelewski _Lumo_ · Answer

You can try to use apps like Excel 365 Connector: https://marketplace.atlassian.com/apps/1222961/excel-365-connector-for-jira?hosting=cloud&tab=overview

It allows to import and export data (from JQL/filters) to Excel, works on multiple sheets, so you could have data from both environments on separate sheets and just compare it and send changes, or create new issues from sheet

(Note: I was part of the team behind the app! 😊)