nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Migrate and Upgrade

Shane Shelley

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

Shane

Accepted answers

Rodrigo Girardi Adami

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.

Rodrigo

All comments

Alejandro Conde Carrillo

An simple upgrade path could be:

Set your new server
Create the new database
Take an XML backup of your current Confluence instance
Install Confluence 4.3 in the new server
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.

AlysonA

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.

Hope this helps.

Shane Shelley

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.

Rodrigo Girardi Adami

Hi Shane,

I hope this helps.

Rodrigo

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

migration

upgrade

database

ms-sql

postgres