It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira Migration, with different usernames

Hello everyone, We are in the midst of migrating roughly 15 Jira projects from one domain to another, varying board complexities from pretty vanilla use to very heavily used boards with links, mentions etc out the wazoo. That 15 will likely grow to 45 by the time we are done with all of our migrations.

We are using the Project Configurator and Jira version 8.2.3

I now realize that username is the attribute. Unfortunately usernames are very different between the domains. They are coming from jsmith and migrating over to our environment which defines their username as their employee ID.

I have come across a couple of potential "solutions" (mucking around in the DB, changing usernames in AD), but I want to reach out here to see if anyone has done this before.

My question is: Has anyone done cross domain migration with different usernames before, if so, was it successful in preserving user data (tickets assigned, mentions etc), and of course, how did you do it?

Really appreciate any help and guidance here.

 

Nate

1 answer

1 vote
Ismael Jimoh Community Leader Oct 27, 2019

Hi Nathan.Dreier@parsons.com 

I have a bit of experience with this. What I did was build a file listing the username and the new username and then updating this using REST API(only works for users in the internal directory).

For you to progress, you will need to rename users in the source JIRA instance to the same username on the destination JIRA instance.

p.s. A direct database update is not something I will recommend. You will need to know the exact place to update the username in. If you are planning to rename the users via LDAP, then make sure you do not create a new entry but rather do the following:

  • Have a new entry added to the existing AD.
  • Edit the current AD settings in JIRA and under users, replace the current entry it checks for username to the new one.

This ensures that it does not create a new user and simply renames the user. (In the DB, JIRA maps users by Username and directory ID).

Cheers.

So let's say that changing names on the old domain is not feasible (several projects, migrating only a handful at a time), we are not migrating all of the services at once so if we change usernames on the old domain that can really cause issues with other services they will still use.

It has been suggested to whip up a script using sed or another method to basically find and replace userX with userY  and just iterate through all the xml's and other files that are exported.


Have you done anything like that?

Ismael Jimoh Community Leader Oct 30, 2019

Hi Nathan.Dreier@parsons.com 

Unfortunately I have not done this before. Also, you would need an editor that is quite large for doing what you mentioned above.

I would normally do the following in a scenario like yours:

  1. setup a staging server
  2. restore the backup there
  3. Perform the rename on the staging server.
  4. Migrate the data with the fixed username.

The original data stays the same and they can access with the same credentials but this does not impact the new server or data we migrate.

Cheers.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

363 views 1 3
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you