how to migrate MSSQL2016 data to PostgreSQL for large data set confluence

[sreenivasulu vadde]

Hi,

We are planning to move from MSSQL2016 to PostgreSQL 11 and our Confluence instance is very large so XML backup is taking more than 15 hours and as per the Atlassian it is not recommend to take XML backup for large dataset confluence,

Any one have any third-party tool for this migration and also any known issues if anyone has already migrated.

Appreciate your help on this.

[Thomas Deiler]

Dear @sreenivasulu vadde ,

when your attachments are located in the file system (and not inside DB), you can create the XML backup file without attachments. On restore, the attachments are already at the right place.

Please follow Method Two in the official instructions for the details.

So long

Thomas