SQL error when migrating Umbraco DB to Azure SQL

Hi all,

using the SQL Azure Migration Wizard tool, I get the following error in around 10 tables, when trying to connect to the SQL Azure instance. The first step for connect to the Umbraco DB is supposed that generate the script without problems.

Starting copy...SQLState = 23000, NativeError = 2627Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_cmsContent'. Cannot insert duplicate key in object 'dbo.cmsContent'. The duplicate key value is (1).SQLState = 01000, NativeError = 3621Warning = [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.BCP copy in failed

Someone could help me in this?? Thanks in advance!

0 answers