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 !