Questions on backing up Confluence and converting to Microsoft SQL

[Ron M]

We're looking to set up a test environment for both Confluence and Jira (we got the Jira piece done), but are running into issues with Confluence. We're on an older version (6.1.1) with the DB being in PostgreSQL and haven't had any luck with creating a backup from it using pg_dump and then restoring to the Confluence instance on the test server. We've tried to take a backup using the Backup & Restore function, but it times out without backing up and I'm not finding any related logs. I realize there's probably lots of info I'm leaving out so please let me know if I can add any info to clarify my issue some more.

End goal is to then update both Jira and Confluence on the test server and convert Confluence DB to Microsoft SQL.