we are running a Jira Software 7.1.7 and are quite happy with it.
The database is setup as Microsoft SQL 2008 R2. We are now planning on migrating to another database or updating to MS SQL 2016.
Has anyone helpful advice?
There are 2 methods one is you can rely on the native DB backup/restore and other one is JIRA XML backup/restore.
We can migrate to another DB, so you have to setup new MS SQL 2016 DB as mentioned here https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2016-948232141.html
Before connecting jira to new MS SQL 2016 DB you should take full XML backup and then connect new DB to jira which should again install as new jira then once you are inside restore the XML. that should do it.
Please take a look at this link which mentions about switching DB for jira https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html
I would recommend to do a test before doing on production.
MS SQL 2016 is officially not supported for Jira 7.1, please check out this supported platforms doc for 7.1 https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2016-948232141.html.
MS SQL 2016 is officially supported in Jira 7.9 and later.
Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...
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