We are currently in the process of migrating our Atlassian products from a Linux/Postgres environment to a Windows/MSSQL environment.
Given the complexity of transforming SQL between engines, and the different way paths are handled, it was decided to the the XML generated by export to perform the migration. Jira worked, with a few minor issues that were recorded in the logs and therefore be addressed immediately.
Confluence did not work, and there was nothing generated in the logs.
Any ideas are welcome. Let me know if you need more details.