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.
Cheers,
Josh
