Compatibility with SQL Server 2017

We want to upgrade our JIRA databases to the new SQL Server 2017 instance for better availibility and performance at our company. Is there any planning regarding support of SQL Server 2017 for newer versions of JIRA in future? Can we wait for a new version release which will be compatible with SQL Server 2017 database?

5 answers

1 accepted

1 vote
Accepted answer

Hey Kanan,

Unfortunately none of the JIRA versions support MSSQL Server 2017 as of yet.

There's a suggestion ticket opened in our system already. Please add yourself as a watcher and vote the issue for it to have more visibility. Being a watcher on a ticket means that you will get notified by all the updates posted on the ticket so you can follow the progress done on the ticket.

Here is the link for the suggestion ticket opened.

Thanks in advance.

Regards,
Martin

Thanks very much, Martin. I have added a vote and watching these issues from now. I hope the priority of these tickets will be raised as soon as possible, because "Low" priority is not the level of this type of problems.

Please, any update on this? SQL Server 2017 is needed!

Do you have a timeframe for when SQL Server 2017 support is coming?
I see with the 7.9 release in April SQL Server 2016 support was added

1 vote

Realting to Peter's post, I also want to know the support date for SQL Server 2017.

We have just updated to a MS SQL 2017 and want to install JIRA for the first time.

There's a hack to run SQL Server 2017 in Compat mode.

It isn't supported though, meaning if anything goes wrong, you can dig down deep into JIRA and debug it yourself :/

@Martin Orzaiz There is posibility to run SQL server 2017 witch 2014 combatibility mode. Will this configuration works properly?

My company migrate to SQL 2017 and i wonder if i have to maintain one serwer in 2014 and second in 2017 OR can i migrate to SQL 2017 wich 2014 compatibility mode?

It will probably work.  But it will NOT be supported, so we can't recommend that you do it.

You'd need to spin up a new test instance on 2017, alter the compatibility level to 2014, then perform rigorous testing of the entire application, workflows and plugins. Don't forget attachments and mail handlers.

(This is also why it takes time for vendors to give the all clear).

P.S. SQL 2019 is around the corner, but still who is game to go with v1 of MSFT SQL.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,100 views 17 14
Join discussion

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