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

Rectify Custom Field ID's between JIRA db's before export/import

Hello, we have two JIRA server environments running. Dev/Prod. They are the same version (8.2.3) and have the same addons. However, they got out of sync as two of our projects had a lengthy development time and were not approved for release as beta on prod during the dev process. As such, the custom field id's got out of sync. There are about 60 differences between the two. Some do exist in both, some exist in only one or the other, and some are overlapped (same id between db's but different types/names on the custom field). In a one off way, we have manually gone through to fix a view of the fields by using something like : 

select * from customfield where id = 12105

and then using a simple "Update" to the correct number. 

update customfield
set id = 12105
where id = 12804


We are looking at some script solutions but nothing seems to be more efficient than just manually re-configuring. Any advice on db tools that can handle this translation/fix or back-up/restore features would be much appreciated!


Thanks in advance. 




0 answers

Suggest an answer

Log in or Sign up to answer

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