How can i copy data (~10000 pages + 5000 attached files) from Confluence 5.3 to Confluence 5.9.2?

[Dmitry Malov]

I have one space ~10000 pages + 5000 attached files on Confluence 5.3 (server installation, PostgaceSQL, attaches stored as files).

I need to copy this space to Confluence 5.9.2.

But at page https://confluence.atlassian.com/doc/restoring-a-site-152034.html written: "Importing an old XML backup file to a new major version (for example, Confluence 5.5 to Confluence 5.6) is not supported."

How can I do it?

[Jonathan Soo · Accepted solution]

Hi Dmitry,

For a large spaces like this, create XML backup is error prompt and it might take a lot of time and resources to do that. If your Confluence only have one space, I would suggest you to export it as a SQL dump and migrate to a newly create database, install Confluence 5.9.2, point Confluence 5.9.2 to the new database.

http://www.postgresql.org/docs/9.1/static/backup-dump.html

Regards,
Jonathan

[Jonathan Soo]

Take a look at the Software Catalogue. Under Administration/development tools I see DBConvert for MS SQL & PostgreSQL. Probably there are other similar tools listed. The converter might be able to help. 

[Dmitry Malov]

I know only one way:

1. Copy Confluence 5.3
2. Upgrade Confluence 5.3 to 5.9.2
3. Backup/restore from Confluence 5.9.2 to Confluence 5.9.2

[Dmitry Malov]

    My Confluence 5.3 use MSSQL and Confluence 5.9.2 use PostgaceSQL ... so I can`t use dump. I can transfer data via SQL insert scripts.