Moving Confluence to another server & DB

[Mark Stocker]

We are on version 3.4 and it's running on a windows 2003 server and the DB is Postgre.

I want to move this to a new windows 2008 server with a SQL Server DB.

Where do I start? Is there a migration and upgrade path?

Any help appreciated.

Thanks!

[MatthewC · Accepted solution]

Hi Mark,

How big is your instance? Can you still get an XML backup? I only ask because once Confluence passes a certain size, the resources required to take an XML backup are often too much for the server & it fails. if you do get out of memory errors when doing an XML backup, you could change the JVM parameters to give you the maximum amount of memory just for the export.

Once you have thet you can then do an XML import of the new instance.

If that still isn't an option then you could do it in stages. Move the application tier to SQL server 2008, leaving the DB on Postgres. Then talk to your DBAs and do a DB to DB transfer.

Either way, I would raise a query with Atlassian Support to make sure you're covered.

Some more redaing for you:

http://confluence.atlassian.com/display/CONF34/Migrating+Confluence+Between+Servers

http://confluence.atlassian.com/display/DOC/Migrating+Confluence+Between+Servers

If you are moving to 64-bit, watch out for the problem with Confluence as a windows service

https://answers.atlassian.com/questions/40018/data-migration-sql-2008-to-sql-2008-r2?page=1#40064

[Mark Stocker]

Thanks, will take a look and have also raised a support request with Atlassian!

[Nic Brough -Adaptavist-]

Duplicate of https://answers.atlassian.com/questions/40408/confluence-upgrade-and-move

[Andrew Frayling]

Hi Mark,

Take a look at http://confluence.atlassian.com/display/DOC/Migrating+Confluence+Between+Servers and
http://confluence.atlassian.com/display/CONF34/Migrating+Confluence+Between+Servers for details of how to move Confluence to a new server.

Hope that helps?

Andrew.

EDIT: If you're also looking at upgrading Confluence have a look at http://confluence.atlassian.com/display/CONF40/Upgrading+Confluence and
http://confluence.atlassian.com/display/CONF40/Upgrading+Confluence+Manually