Migrating Large Confluence DC Instance From MSSQL to PostgreSQL

[AJITH PG]

Hello All,

I'm planning to migrate Confluence DC version 9.2.15 from from MSSQL to PostgreSQL. I have a pretty large instance with big DB and lots of attachments. So, Site export including attachments is not an option for me. DB conversion is also not an easy task considering the size of the instance. Space level migration is not an option as the Page IDs will change and that impacts our user base. 

So, my plan is to do a Site XML export by excluding attachments and restore the same into the new instance and use the old attachment folder to point the new instance to the attachments. There won't be any change in the attachment folder hierarchy and XML exports will be having the same I guess. Anyone ever tried a similar thing? Would like to get some recommendations.