We need to move our SD to another server.

We upgraded SD at our old server to v.7.6 b. We  also installed the same latest version to a new server. We made a backup from the old server and now we can't restore it to a new server.

RestoreData tries to restore it but when it gets to the end, we get errors:

 

Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
================================================QUERY = INSERT INTO wordoccurren
ces (WORDHASHID,COLUMNID,WORDCOUNT) VALUES(2076854327, 12008, 1);

java.sql.BatchUpdateException: null,  message from server: "Duplicate entry '198
9861112-12011' for key 1"
        at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:338)
        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 : null,  message from server: "Duplicate entry '19898
61112-12011' for key 1"

 

Please advise!