When restoring MYSQL data in MSSQL database getting error like “Violation of UNIQUE KEY Constraint (table name). Cannot insert duplicate key in the object”
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.