ISSUE WHILE MIGRATING MYSQL DATA OVER MSSQL.

ISSUE DESCRIPTION: 

When restoring MYSQL data in MSSQL database getting error like “Violation of UNIQUE KEY Constraint (table name). Cannot insert duplicate key in the object”

 0

In the above case  Asset->Software-&g

ISSUE WHILE MIGRATING MYSQL DATA OVER MSSQL.

ISSUE DESCRIPTION:  When restoring MYSQL data in MSSQL database getting error like Java.sql.BatchupdateException: Violation of UNIQUE KEY Constraint ‘usersitemapping_UK’. Cannot insert duplicate key in object &#8

Duplicate entry while restoring data

Cause:

When inserting a word in mssql with trailing space like “service desk”, the word is inserted as it is. However, when inserting the same word in mysql, the word “service desk ” is trimmed as “serviced

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500