Migrate Jira 6.4/SQL2005 to Jira 8.2/SQL2014

Todd Stidham

I have an older Windows 2008 server running Jira 6.4 using an even older Server 2003/SQL 2005 database server (*see notes at bottom before commenting on server 2003). For obvious reasons, we need this all moved to newer servers and SQL. I will be moving the application to a 2012 R2 box with the latest 8.2.4 release and planned on restoring the database backup file to a SQL 2014 Database Server. What is going to be the best order for doing this? I figured I would do:

1. Copy Jira_Home and Install folders to new server, delete dbconfig.xml

2. Restore .bak file from 2005 server to 2014 server. Create Jira_user login and assign dbo role to Jira_db

3. Run latest Jira-core-8.2.4-x64 windows installer and point to the copied install folder and jira_home folder.

4. Run Jira setup wizard to connect to database.

However, we do use Active Directory authentication so didn't know if there were any other config xml files to mess with.

Also, wasn't 100% sure if I should copy the existing 6.4 install folder and let the 8.2.4 overwrite/update it OR don't copy the install folder and let the installer create a clean install. 

Any thoughts (and prayers) are appreciated! Thanks.

* Yes, you read that correctly, Server 2003. Yes, I know. Yea, I said the same thing to my higher ups. I know but what could I do? They said "it ain't broke so don't fix it". Thank fully the BlueKeep exploit finally scared them into action...but of course now they want it done last week. Thanks again for the help and understanding.

Dave Theodore [Coyote Creek Consulting]

No prayers necessary! We're here to help!

First things first, though.  You need to read over the Supported Platforms page for Jira 8.2 and make sure you use a supported database and Java. Next, you need to read the Upgrade Notes pages (link to 7.0) for each version between 6.4 and 8.2.  It might not seem like a big jump, but 6.4 is more than 3 years old, so it is a big jump.  If you are using Jira Agile now, you want to read those notes as well. Just update Jira Agile to the latest version for 6.4 and you should be good, though.  Pro-tip on searching the docs: Use google and enter the following format "jira 7.0 upgrade notes" "jira 7.3 supported platforms" etc.  Just change the version you want to look at. The release notes have a drop down you can select version with. I would also read over the Jira 7 migration hub docs. There were significant changes made to 7.0 and it affects licensing and the way you grant access to things.

The part that gets really messy is generally the database.  You will need to jump to a modern database, but you need to make sure that any interim versions of Jira are running a supported database.  This may mean that you need to do multiple database upgrades as well. There may be 3rd party Add-ons/Apps that are not available for modern versions of Jira, so I suggest doing an audit on them as well.

Hopefully you aren't running Jira Service Desk.

Obviously, do this in a development environment first, identify a repeatable method, then use that method to upgrade production. Good luck!