Day: November 9, 2020

SSMA : Violation of PRIMARY KEY constraint

While running SSMA migrates Oracle database to Microsoft SQL Server, the constraint violation errors occurred for some tables as below:

Violation of PRIMARY KEY constraint ‘TABLENAME_PK’. Cannot insert duplicate key in object ‘USER.TABLE’. The duplicate key value is (John).

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Advertisement