Upgrade Confluence 5.6.1 from Win7/HSQLDB to 5.7.3 Srv2008/MSSQL

Hello Community !
I want to Upgrade/Install from Confluence 5.6.1 running under Win7 and the embedded HSQL to a Win 2008 Srv with MSSQL database. We have a 10 user license and about 400 pages with 28MB attachments. It is a small installation yet. So, should I

  • Upgrade my existing installation 5.6.1 to 5.7.3 on the Win7P
  • backup the old data as XML backup
  • Install 5.7.3 on the Srv and create a naked SQLDB
  • restore the data into the fresh installation


Do I need a developer license on the new Srv during the swap ? Or is there any other easier way ?

Thank you for your help !!

3 answers

1 accepted

0 votes
Accepted answer

Thank you Chander for your answers. Do you know if the jdbc bug is resolved with the new 5.8.4 Version ? We really really have to do the update in the near future smile



3 votes

Hi Fritz,

I do recommend to switch first to a supported database because using HSQL DB in production is not advised. Since the instance is small, try to use the XML backup to import into the 2008 server and MSSQL DB using the exact same version as the production.

After the migration has been done, proceed with the upgrade. Be careful of this bug in 5.7 when using jdbc MSSQL Database. You need to switch to datasource to perform the upgrade and change back to jdbc afterwards.


You can use the evaluation license to create the staging instance. After you finish the migration, you can set the 10 user license in the new server. Just change the server ID in my.atlassian.com to reflect the new ID of the new server.

I hope this helps!



Hi Rodrigo, meanwhile the actual Confluence Version is 5.8.4, and we found no time to do the upgrade, are your recommentations still up -to-date ? Is the jdbc bug gone with the new release ? Next week we will give it a try to perform the upgrade to the SQL driven Server Installation of Confluence. Hope to read you ...

Hi Fritz,

  1. Create a FULL XML backup of 5.6.1 
  2. Install 5.6.1 on Srv
  3. Create an empty SQL Server Database
  4. Restore the XML Backup of 5.6.1
  5. Before Upgrading to 5.7.3
  6. switch to from jdbc to datasource

    • After you set the new installation files of 5.7.3 to point your current <Confluence HOME> directory run the steps in this guide to switch from jdbc to datasource.
      Backup all the modified files.
    • Start Confluence again.
    • After the upgrade, validate if Confluence is working.
    • Shutdown the app and change back to jdbc.
    • Start Confluence again.
  7. Hope this helps.
  8. Please use 10 user license on Prod Server.


Chander Inguva


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,116 views 59 8
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