Migrate Postgres 9.2.18 Confluence database to SQL Server 2016

Hi,

I want to migrate my Confluence database from Postgres 9.2.18 to SQL Server 2016, however on your supported platform page  it shows only  Microsoft:

  • SQL Server 2012
  • SQL Server 2014

Could you please let me know if there is any plan in near future to support SQL Server 2016.

Or Do you think I can still upgrade to 2016 and remained covered for Atlassian support?

Regards, Ajay Prakash(+44-7889670565)

 

Current setup:

View System Information - Confluence Database Information

Confluence Version6.3.3
Build Number7202
Database name

 

PostgreSQL

Database version9.2.18
Database Dialectcom.atlassian.confluence.impl.hibernate.dialect.PostgreSQLDialect
Database Driver Nameorg.postgresql.Driver
Database Driver Version42.1.1
Database Connection URLjdbc:postgresql://localhost:5432/confluence
Database Connection Transaction IsolationRead committed
Database Latency0

3 answers

0 vote
Peter DeWitt Community Champion Dec 05, 2017

 

@IT_nyc, not sure about Atlassian's official stance on this but I think it will work.  I believe we were running 2016 at my last place.  Anyway, try it in a dev environment and see.  

As far as support ramifications, I would send a support request directly into Atlassian.  I know they watch the Community but a direct issue will be faster.

.pd

Thanks @Peter DeWitt.

My gut feeling is that, Yes, it would work seamlessly, 1% I never know if something behaves funny.

Eventually this system will be used as PROD and there is no Dev system at the moment.

0 vote
Ann Worley Atlassian Team Dec 05, 2017

On the Supported Platforms page:

You should only use Confluence with a supported platform. Any platforms and versions not listed on this page are unsupported, which means we don't test, fix bugs or provide assistance.

Since we don't test with SQL Server 2016, we cannot predict the way Confluence will behave with it. For a Production environment it is safer to use a supported platform.

@Peter DeWiit Ajay seems to have a starter license so he is contacting support by posting here. :)

@Ann Worley: Is there any planned date to include SQL Server 2016 in supported platform list?

Peter DeWitt Community Champion Dec 05, 2017

Thanks @Ann Worley. :)

Ann Worley Atlassian Team Dec 05, 2017

@IT_nyc I meant to link this in my other answer - there's no projected completion date but it's a way to keep an eye on our progress: Add support for Microsoft SQL Server 2016

We take customer votes into account when planning the bug fixes, so please vote on it.

thanks, done that. One last question !! Does it support running Databases in SQL 2014 compatibility level on SQL 2016 instance?

Regards,

Ann Worley Atlassian Team Dec 07, 2017

Thanks for voting. :) As Confluence wasn't tested on SQL 2016, it wasn't tested with 2016 in 2014 compatibility level, either, so I cannot accurately answer as to how it will perform.

Adam Barnes Atlassian Team Dec 18, 2017

Check out my latest update on the issue.

Peter DeWitt Community Champion Dec 20, 2017

@Ann Worley, some feedback for the Atlassian Team.  It seems strange that we would need to vote for the current version of SQL to tested for Atlassian products.  I would expect that the big three, Oracle, MS SQL, and Postgres would be automatically tested for the major releases....

Ann Worley Atlassian Team Dec 20, 2017

Hi Peter,

We use suggestion tickets like Add support for Microsoft SQL Server 2016 to help measure customer interest in a feature. Users don't have to vote to get us to test against new releases of existing supported platforms. I didn't mean to give the impression that we would not test against new MS SQL releases if no one voted.

Thanks,

Ann

Peter DeWitt Community Champion Dec 20, 2017

ok thanks. :)

0 vote
Peter DeWitt Community Champion Dec 20, 2017

For anyone else reading this post.  I have checked with a colleague of mine and he is also running SQL 2016 as the DB for all of his Atlassian apps so it does work even if it's not officially supported. 

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

901 views 23 12
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