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->Scanned Software has some software manufacturer with unknown characters.

 

Steps to Fix:

Step 1: Login to Servicedesk Plus MSP as administrator

Step 2: Goto Asset->Software->Scanned Software, delete the software manufacturer’s with unknown characters.

Step: Now take a new backup and try to restore.

 

 

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