Upgrading Confluence and Database together

I'm a bit stuck on this one.

I have 2.7.4 on windows server 2008 connecting to an SQL 2000 database (this is the interim step from 2.6.0)

I need to get to 3.5.7 on windows 2008 connecting to an SQL 2008 database

2.7.4 doesn't seem to support a 2008 DB, while 3.5.7 doesn't seem to support a 2000 DB

So I'm in a bit of a chicken and egg situation I think. I can't upgrade the software install to point to the old DB and I can't upgrade the DB and point the existing install to it (or can I?!)

2 answers

1 accepted

I would need to check the various details - but you should be able to use the xml export import method.

export your current data to xml then import that into your empty new version and DB.

You may be better off hopping to an intermediary verison first rather than try to go all in one step, and that may enable you to move using the more automated in-situ db upgrade.

Else follow the instructions for moving to new Database:

http://confluence.atlassian.com/display/DOC/Migrate+to+Another+Database

Hi Martin, I didn't think you could do an upgrade and a DB migration at the same time?

I'm thinking 2.9 might be the next step as it Supports 2005 and works with 2000, but then I'll need yet another DB created.

Atlassian support have advised I shouldn't need another step (already gone 2.6.0 to 2.7.4), but I can't see how else to do it.

In normal circumstances, its not advised you want to de-risk as much as possible - but the xml is database independant making your confluence data pretty portable in reality. As always would test first of course.

From a quick check, 2000 support was last mentioned in 2.8. 2.9 only lists 2005

http://confluence.atlassian.com/display/CONF29/List+Of+Supported+Databases

(2.7.4 is the minimum version from the confluence side)

Yeah, this is the test migration. Will give it a go

0 vote

I upticked Martin's answer, it's basically the same one I'd give. One caveat - the XML backup is notoriously unreliable. If you hit an error you can troubleshoot it. Start with XML Backups and Space Exports Troubleshooting and find the error in the logs for the article you need from there.

Alternatively, you can run the upgrade to 3.5, then use a native database tool to migrate your data from 2000 to 2008 (I bet it will work, it's just not supported - it had performance problems and we deprecated it for that reason).

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

370 views 20 10
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