combining 2 different versions of JIRAs into 1 and upgrading to latest

Hi all,

I hope someone can help me.  Here is my situation I have been hired into:

Currently two production JIRA's running:

  1. Main one Version 6.2..7, with MsSQL DB, Confgured with LDAP
  2. Version 6.3.12 with HSQL DB, Local users

I need to combine these into a single JIRA instance, running on the company VM, and upgrade to latest version. I have tried many thing here are a few with their results:

  • Install 6.4.7 on a new machine and restore #1 import #2, doesn't work as #2 has be identical version for import
  • Install 6.3.12 on a new machine restore #1 and project import #2.    This worked after a lot of massaging.  Then I tried to upgrade it to 6.4.7 and it crashed hard, as there were a ton of issues from #2 with invalid users, and other things.  Even after I hacked the DB and changed all unknown users to my uid it still was left with a JAVA crash.
  • Create matching copy of the two projects on #2 and copy the configuration and issues through JIRA configurator and JIRA to JIRA copy.  I could not get the later to copy the issues.

I am at a loss for any ideas.  I am trying to avoid upgrading #1 first as I it will need to be moved anyhow.

Thanks in advance,

Robert

 

 

3 answers

1 accepted

1 vote

#2 is perhaps not production data since it is using HSQL. I would upgrade #1 to the latest version and then discuss how to import the data. Project Import is hard to get right. I generally prefer to use the CSV importer which will handle core data, comments and attachments but not links etc. The advantage of extracting the data from #2 using is that you can modify the usernames at the same time

Yes #2 is production (scary right), long story before I hired on. I may try the CVS imported if above doesn't work. Thanks!

The CSV export kind of works, lost the comments, but is something that actually party worked! Thank you. How do I create a CVS file from JIRA? I went to search and Export CSV all fields, but then I seem to lose comments. Also, I had to go into the Excel and manually fix by doing a search for all "," and replace with "." as well as it saved things like multiple values for Fix/Versions into the same column. Since it is required to have them in two columns upon import, I was hoping it would save them that way in the export...

Have you tried to backup as xml then import it?

For #2? #1? or both?

NM Yes that is how I back it up. FOr both #1 and #2.

what you could do is create another JIRA on 6.4.7, restore with #2 then export asXML. Now you have a backup with the same version of JIRA as #1 that you can import. Hope this helps

Great Idea! unfortunately the restore of #2 died with Java errors. Not looking good.

With complex scenarios like this, many organizations turn to an Atlassian Expert to do the consolidation and upgrade. There are many steps and precautions, and sequencing is crucial. Also, sometimes the consolidation path requires custom development to augment what the product's built-in functionality cannot address. And it sounds like your Production installation is far from being configured according to best practices. Sometimes having an Expert point that out can allow management to receive the bad news better. wink

Hi Betsy, been there and had to undo much of what the "experts" did. Thanks but no thanks.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

Mission-critical battery manufacturer fulfills FAA software requirements with Commit Policy Plugin

EaglePicher Technologies is a leading manufacturer of battery systems for diverse industries like defense, aviation, space or medical. As they operate in highly regulated industries, keeping a clear ...

143 views 0 2
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you