Migrating Jira to new hardware - Copy user data to a new user

[Lawrence te Vruchte]

Hi There,

We are currently migrating Jira to new hardware. All has been migrated, and the server is now up and running. 

We only have an issue with a single user. The users are stored and handled via LDAP. With the creation of the users in the new LDAP a small typo (e.g. userwrong) has been made, so this user has been updated in LDAP (e.g. userright). Unfortunately has Jira now added a second user (with correct data, user right) and put the original user towards the user wrong. So within Jira there are 2 users, whilst in LDAP there is only one user.

With a fresh system this is no problem, but we are using our system for some years, and the user wants to make use of all his precious filters/dashboards/etc.

So the question is, how can I copy this (old) user data, towards the new user?

[Tom Lister · Accepted solution]

Hi @Lawrence te Vruchte

take a look at my posts for a solving a domain migration problem which has similar issues

https://community.atlassian.com/t5/Jira-questions/Move-work-logs-to-another-user/qaq-p/928894#M298313

[Tom Lister]

This may also help with ownerships 

https://confluence.atlassian.com/adminjiraserver073/managing-shared-dashboards-861254015.html

[Lawrence te Vruchte]

great tnx tom!! it worked.

I have here some additional tables which I also updated. (in case someone else need to do something similar)

• portalpage (username field)
  Dashboards of the user.
  Note: be carefull with updating these fields. It can occur that jira doesn't know anymore which dashboard to be displayed of the provided list. This can result in an 500 error for the user when logging in.
• portletconfiguration
  This contains the configuration per dashboard
• jiraaction (author,updateauthor)
  Comments upon an issue
• changegroup (author)
  History of a Jira
• change item
  History of a Jira

[Tom Lister]

Hi

Thanks for feedback. I didn't do it on a service desk so didn't come across the portal tables.

I had an issue with dashboards in that the mapped user had already set up a dashboard and had duplicate key error - ended up deleting duplicates during migration.