Copy user-group-permission from one JIRA instance to another


I have 2 different JIRA and one will be migrated to the other. I have to migrate all the spaces users and groups to the new instance.

I'd like to ask you for help how could I copy the user-group-permission structure, i.e. don't need to grant the permissions and group one by one in the new instance.

Can this user-group-permission structure be export to an xml?

I would like to spare the time because there ar about 300 users, 40 groups....

Thanks in advance!

Best Regards,


1 answer

Is the second Jira brand new or does it already have data? What version of Jira are you using? Are you shutting down the source Jira?

If the second Jira is brand new there are 2 options that come to mind:

1. Yes, you could export the entire Jira instance as XML and the import it in the new instance. This will entirely clone the second Jira instance.

2. You could also do this with SQL. What version of Jira are you using? In Jira 4.3 and later all the user management data are stored in tables that start with CWD_. You could dump the DML SQL for those tables and recreate it in the second Jira's database.

If the second Jira has data alread and needs to keep it and you're leaving the first Jira online and we're talking about Jira 4.3 or later, you could delegate all user management and authentication for your second Jira to the first Jira using the built-in Crowd in Jira.


the second JIRA is not new: it has already data. I can migrate 300 users one by one, but I also have to create the groups for them and the user-group mapping too. Because my JIRA is connected to Confluence and I grant the permissions to Confluence Spaces via groups, then it's also gonna be a long term to give the permissions for each groups.

The source Confluence's version is 3.0.2, the new one 3.5.13.

I moved all the spaces from the source system, I can copy all the users and groups from the source system but the user-group mapping I don't want to do one by one.

Can you give me some trick?

Many thanks!!


Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Thursday in Off-topic

Friday Fun: Magic Eyes

...staring into the background. Once the image pops out in 3D, you can look around the picture and enjoy. If you will see if you are a true illusion master! :) You did it? :) Wow! Awesome! As a bonus...

461 views 83 11
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you