E
E
emashev2019-10-16 21:07:57
SQL Server
emashev, 2019-10-16 21:07:57

How to migrate from postgresql to mssql?

It was required to transfer all data from postgresql to mssql.
I made an xml backup, which I deploy to a freshly installed service.
But there are errors like this:

Не удалось импортировать. Проверьте логи сервера для получения дополнительной информации. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLServerException: Не удается вставить повторяющуюся строку ключа в объект "dbo.user_mapping" с уникальным индексом "user_mapping_unq_lwr_username". Повторяющееся значение ключа: ().

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-10-16
@emashev

Here either
Either set for the field
Sort option

You can't repeat NULLeither.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question