Jira 6.0.8 upgrade and database migration advice needed

Currently our version of JIRA AND our db are EOL.  We have JIRA 6.0.8 and MySQL5.0 - the goal is to move to SQL server 2012.  We can't go lower than that, and JIRA 6.0.8 does not support SQL Server 2012.

Soooooooo..... my current plan is to:

  • Take a snapshot of the server
  • Back up to XML in case it all blows up
  • Upgrade JIRA in place to version 6.4
  • Backup again to XML (just in case)
  • Create a new SQL Server 2012 database for Jira
  • Connect JIRA to the new database
  • Restore data from the 6.4 backup 
  • Have 20 pints (give or take)

Would this work?  Is this a crazy, misguided plan?

1 answer

This widget could not be displayed.

Step 1: You should ALWAYS make a complete backup of JIRA before you start.

Step 2: Upgrade your JIRA.

Step 3: follow these instructions to change the database  https://confluence.atlassian.com/adminjiraserver071/switching-databases-802592192.html

This way i don't see why it would not work and It's not crazy at all. I'm just wondering. Any specific reason you don't upgrade to the latest JIRA version?

Well, it seems less risky bringing us to 6.4 instead of 7. 

The driving force here is a MySQL vulnerability (and being EOL), not the JIRA upgrade.

If you are planning to make these changes then why not go all the way?

check plugin compatibility to determine what the highest version is you can install

Create a duplicate of the server (test environment) and try it out.

If you plan on going to the newest version do incremental upgrades in the test version.

Check after every upgrade to make sure everything still works. And who knows, maybe there wont be any problems upgrading to the latest version.

If you decide on upgrading your production environment to 7.X always upgrade to version 7.0 and then you can upgrade to 7.X.X

If you have scriptrunner and a lot of scripts it could be you have to rewrite a few of the scripts. 

But most of the time it should be no problem upgrading to the latest version.

 

At least, that is what i would do, but the choice is yours of course. wink

Well, I need to get this done asap, can't go through all the incrementals.  6.0 to 6.4 seems safe, then a jump to 7 maybe.  Well, I might just shred my test server and try going straight to 7.

David Currie Atlassian Team Sep 14, 2016

There's no need to do incremental upgrades unless you're moving from 3.x to 7.x, or you're using Agile (in which case https://confluence.atlassian.com/jirakb/this-version-of-jira-agile-requires-a-minimum-build-number-of-45-in-order-to-proceed-812222943.html may apply).

If you're happy to stay on an EOL JIRA and only want to move off MySQL, you can switch databases as per https://confluence.atlassian.com/display/jira060/Switching+databases.

Aie, so I ran the update, only to discover, surprise, that we had a JIRA Software license, not Core, and then, surprise, you can't go from 6.0.8 to 7 directly... but nothing states this.  Nothing except JIRA 7 when it tells you as you're restoring data that it won't work.  SOOOOOOOOOOOOOO.... the upgrade in place failed, and uninstalling 7 took all my plugins with it, so.....

FML

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published yesterday in Marketplace Apps

The 7 hacks of highly successful automation

...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...

83 views 0 8
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