You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
We are migrating our domain from "at.xxxxx.com" to "xxxxx.com" (both in the same forest) and want our users to use their new usernames in the new domain while keeping the same permissions and contents from their old usernames. Apparently the only solution or workaround is this:
How to merge two users' content ownership and permissions in Confluence | Confluence | Atlassian Documentation
I did proceed with this and converted queries to MSSQL but at some point it returns errors. For instance:
ALTER TABLE user_mapping DROP PRIMARY KEY;
Returns an error like:
Msg 3725, Level 16, State 0, Line 1
The constraint 'PK__user_map__E1CC8CC0D5F8' is being referenced by table 'LABEL', foreign key constraint 'FK_LABEL_OWNER'.
Msg 3727, Level 16, State 0, Line 1
I manually removed the key using the Object Explorer interface but I am not sure if it is correct. Again, while performing the next queries I get some errors with the queries. Has anyone recent experience with this?