Return
-
Title
Error "Violation of PRIMARY KEY constraint" -
Description
Violation of PRIMARY KEY constraint '<Primary_Key_Name_Here>'. Cannot insert duplicate key in object 'dbo.table_name_here'. The duplicate key value is (<id_here>) -
Cause
The cause for this could be one of 2 reasons.
1. There are actually to values using the same mappings in your mapping section
2. The data is already in the database and it is using a Unique Primary key
-
Resolution
To resolve the above issues:
1. Remove the duplicate value in the mapping and try again
2. Clear the record from the database you are migrating to