Migrate and Upgrade

hi, we currently have installed Confluence version 2.9.1 installed running on Solaris and postgress. Our aim is to upgrade to the latest version (currently 4.3) and migrate to Microsoft SQL Server 2008 R2 on Windows Server.

Can you please advise on the upgrade path.

kind regards


4 answers

1 accepted

Hi Shane,

thanks for clarifying. Actually the process of using the XML is the best for migrating between databases, but you won't be successful uploading an XML from 2.9 to a 4.3. You must first generate an XML in 2.9 and import into another 2.9 using the MSSQL DB. Then you can upgrade confluence in that server using the new database.

I hope this helps.


An simple upgrade path could be:

  1. Set your new server
  2. Create the new database
  3. Take an XML backup of your current Confluence instance
  4. Install Confluence 4.3 in the new server
  5. When prompted, load the data from the XML back up

Please take this as a personal advice: Why are you willing to migrate to a Windows server? I personally preffer *nix platforms and Postgres to MS SQL.

Hi Shane,

Something important to note is that since you're planning on upgrading from a 2.9.* version, you NEED to take some intermediary steps in order the upgrade to succeed, so you can't simply restore a 2.9
1 XML backup into a 4.3, it will definitely fail.

In this case, the upgrade path should be: 2.9.1 > 3.0 (introduces a new license version) > 3.5.17 > 4.3 by following the upgrade instructions outlined in https://confluence.atlassian.com/display/DOC/Upgrading+Confluence.

this helps.

many thanks for all your help.

We want to try SQL Server becuase we has support for this database. We dont have any exposure to MySql. Any advice is welcome.

Suggest an answer

Log in or Join to answer
Community showcase
Louis De Jaeger
Posted yesterday in Off-topic

Friday fun: your best joke

Hi all Lets make this Friday fun really fun and post one (or more) of your best jokes! The joke can be about an Atlassian product, or just a really fun joke you want to share! I’m not the best j...

145 views 12 3
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot