Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Migrating Confluence or JIRA users by database query

Jim Abraham December 10, 2018

I have a Confluence instance with a number of users in the Confluence Internal Directory, for example, "Fred Flintstone", username "fred". "fred" has lots of history attached.

We synched the corporate AD, which is read-only for us. The user Fred Flintstone, for example, has a corporate AD username of "fred.flintstone@bedrock.com" At synchronization time, the AD users have no history attached.

There's no obvious migration strategy for us, given that our AD directory is read-only. Nor can I just change the username "fred" to "fred.flintstone@bedrock.com" and move the Confluence internal directory down in the ordering -- no duplicate usernames are allowed.

I've read all the docs and the suggestions on here, but none of them cover this specific case. It seems to me the only strategy is to

replace name, external_id, directory_id, etc of the internal user with those values from the ad user, then delete the ad user record from the database.

However, this seems brittle and scary. I need a sanity check.

1 answer

1 accepted

0 votes
Answer accepted
Thomas Deiler
Community Champion
December 11, 2018

Dear @Jim Abraham,

before you mess up your DB, check out if this plugin can help: https://marketplace.atlassian.com/apps/1215121/user-updater-for-confluence?hosting=server&tab=overview

So long

Thomas

Jim Abraham December 11, 2018

Thanks, I'll check it out.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events