Migrate Postgres 9.2.18 Confluence database to SQL Server 2016

[IT_nyc]

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 Version	6.3.3
Build Number	7202

Database name	PostgreSQL
Database version	9.2.18
Database Dialect	com.atlassian.confluence.impl.hibernate.dialect.PostgreSQLDialect
Database Driver Name	org.postgresql.Driver
Database Driver Version	42.1.1
Database Connection URL	jdbc:postgresql://localhost:5432/confluence
Database Connection Transaction Isolation	Read committed
Database Latency	0

[Peter DeWitt]

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. 

[AnnWorley]

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

[IT_nyc]

Thanks @AnnWorley

[IT_nyc]

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

[Peter DeWitt]

Thanks @AnnWorley. :)

[AnnWorley]

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

[IT_nyc]

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

Regards,

[AnnWorley]

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.

[barnesy]

Check out my latest update on the issue.

[Peter DeWitt]

@AnnWorley, 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....

[AnnWorley]

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]

ok thanks. :)

[Peter DeWitt]

@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

[IT_nyc]

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.