Hello, I have problem with migration from postgresql db to MSSQL. When I export XML and try to import. I have problem with duplicate key. I find some solution but not work. both Confluence run on MS Windows and one on PostgreSQL and second (new) on MSSQL. Can I create XML backup without users? Or can you take me some diferent advice.
1.step - I create XML backup (PostgreSQL)
2.step - Import to new Confluence (MSSQL)
3.step - Import faild because can not import duplicate key row.
Import can not finish. For more information check server protocols.
com.atlassian.confluence.importexport.ImportExportException:Unable to compelete import because the data does not match the constraints in the Confluence schema. Cause:SQLServerException: Cannot insert duplicate key row in object 'dbo.user_mapping' with unique index §§user_mapping_unq_lwr_username . the duplicate key value is ().
Thank you