I'm attempting to restore a database file from our live SDP server to a DR SDP install. The Live server is running a SQL 2008 database, while the DR site is using MYSQL.

I'm pretty sure I managed to do a cross platform restore, but I am receiving this error when I attempt to do so.

Microsoft Windows [Version 6.1.7600]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

E:\ManageEngine\ServiceDesk\bin>restoredata

********************************************************************************

*

                         Restore DB Setup Wizard

********************************************************************************

*

Execute Restore DB Utility from command prompt

        For Windows users :

                bin>restoreData -c [backup file]

        For Linux users :

                bin]#sh restoreData.sh -c [backup file]

********************************************************************************

*

You chose to open this file: E:\Restore Data\SDP Backups\SDP_Backup_Folder\backu

p_SQLSDP_7611_fullbackup_09_20_2010_01_25.data

File name is :  E:\Restore Data\SDP Backups\SDP_Backup_Folder\backup_SQLSDP_7611

_fullbackup_09_20_2010_01_25.data

 requestScheme is http

Please wait extracting backup file

20-Sep-2010 09:53:14 com.adventnet.j2ee.deployment.service.internal.JarExtractor

 extract

INFO: Extraction for E:\Restore Data\SDP Backups\SDP_Backup_Folder\backup_SQLSDP

_7611_fullbackup_09_20_2010_01_25.data  to E:\ManageEngine\ServiceDesk\bin\..

Active DB Server = mssql

Database connectionProp : null

Database started

*************************************************************

         Backpup data    : Mon Sep 20 01:25:14 BST 2010

         Database name   : SQLSDP

         Total Tables    : 904

         Database Server : mssql

         Build Number    : 7611

*************************************************************

20-Sep-2010 09:55:16 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: rootDir :: ..

20-Sep-2010 09:55:16 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: netutilsData :: {RELEASE={version=7.6.0}, BUILD={number=7611}}

20-Sep-2010 09:55:16 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser

viceDesk Plus}, ADMANAGER={name=ADManager}}

Please wait ! Deleting table data in Progress..

0-----------------------50------------------------100(%)

===================================================

Please wait ! Restoring in Progress...................

0-----------------------50------------------------100(%)

================================================QUERY = INSERT INTO WordMap (APP

LICATIONID,WORD) VALUES(1, N'</font><a');

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:316)

        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'.

Can you shed any light on this?

Thanks