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?
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.
@TP 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?
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.
Well we took the bullet and have been using sql2017 for about close to 2 years without any issues.
But since it was not possible to use sql2017 purchasing and setting up another server (on premise) we had no choice but to try sql2017 and to date no issues.
Of course we are using Jira in a simple configuration, but to date have had not issues. We are not running in compatibility mode.
With regards to 2019 that is a wait and see. I am glad that Atlassian is again supporting the Jira tool, but to with regards to the comments of SOOO many people, we don't have separate MS SQL server for Confluence and Jira. Hence don't understand why Atlassian is not supporting Jira in the same way they support Confluence, when Jira supports a SQL back end then so should Confluence. MS put sooo much into 2019 that we are very suspicious as to how bug free this version is. But for now we are NOT adopting 2019 and see how others experience with 2019 is.
My 2 cents.
WOW I was wondering!!!!! Like what? Altassian is announcing support for MS 2019 at or around the time MS releases 2019 for production! Wow a first!!! and VERY IMPRESSIVE.
Have had fun writing this,
I am VERY pleased with the MS SQL 2017 support. This is in someway much more welcome.
Hopefully sooner that later Atlassian will support MS SQL 2019 as it works both on Linux and Windows. For many this will be very important as we look to move to the cloud and Linux being sooo much cheaper than Windows. Of course MS SQL is not cheap but if it turns out to be efficient under Linux, moving from a MS SQL to MS SQL database is so simple it should work well, if they support the same binary files.
I will check it out and upgrade our instances in due time.
Hey there! When you can pack so much information onto a Confluence page, it can be challenging to whittle down what’s most important. Here are a few of our favorite hacks for finding need-to-know i...
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