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

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

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

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 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

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.....


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

968 views 7 0
Join discussion

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