Change MYSQL to MSSQL server

Change MYSQL to MSSQL server

Dear all ,

I have Services Desk Plus Version : 7.5.0 Build 7509

In first time i setup with MYSQL , now i want change to MSSQL server 2005 so i have lab test , i backup database and restore with new server with MSSQL , this is error


Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
===============================================QUERY = INSERT INTO wordmap (APPL
ICATIONID,WORD) VALUES(1, N'/> </imagedata');

java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'WM_PK'. Cann
ot insert duplicate key in object 'dbo.wordmap'.
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:311)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:141)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:91)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
        at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of PRIMARY KEY constraint 'WM_PK'. Cannot
 insert duplicate key in object 'dbo.wordmap'.



















How do i fix it ? Thanks alot !

                  New to ADSelfService Plus?