Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Updating / migrating Database on Jira 7.1.7

Dear Community,

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?

Thanks

Peter

1 answer

1 accepted

2 votes
Answer accepted

Hey @PeterN 

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.

Regards,

Vishwas

Thank you so much - does 7.1.7 work with MS SQL 2016 at all?

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

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

529 views 19 25
Read article

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