Error migrating to MSSQL from MySQL on version 6.0 rev. 6001

Error migrating to MSSQL from MySQL on version 6.0 rev. 6001

Hello, I'm getting the following error when Converting my Support Center Database to MSSQL. The empty database was created already successfully on SQL Server (which is sitting on the same machine) but when running the conversion utility I get the below error:

Please wait extracting backup file
May 9, 2007 12:33:57 PM com.adventnet.j2ee.deployment.service.internal.JarExtrac
tor extract
INFO: Extraction for D:\AdventNet\ME\SupportCenter\backup\Backup_scp_6001_05_09_
2007_11_43.data to D:\AdventNet\ME\SupportCenter\bin\..
Active DB Server = mssql
Database connectionProp : null
Database started

*************************************************************
Backpup data : Wed May 09 11:43:38 EDT 2007
Database name : supportcenter
Total Tables : 709
Build Number : 6001
*************************************************************

May 9, 2007 12:34:25 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rootDir :: ..
May 9, 2007 12:34:25 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: netutilsData :: {RELEASE={version=6.0.0}, BUILD={number=6001}}
May 9, 2007 12:34:25 PM com.adventnet.servicedesk.server.utils.SDDataManager <in
it>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=AdventNet Manage
Engine SupportCenter Plus}}


Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================


Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
================================================QUERY = INSERT INTO wordoccurren
ces (WORDHASHID,COLUMNID,WORDCOUNT) VALUESnull
java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'WO_PK'. Cann
ot insert duplicate key in object 'WordOccurrences'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:267)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:120)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:80)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java
:317)
java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'WO_PK'. Cann
ot insert duplicate key in object 'WordOccurrences'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:267)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:120)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:80)
at com.adventnet.servicedesk.tools.RestoreDialog.main(RestoreDialog.java
:317)
Unable to restore database : Violation of PRIMARY KEY constraint 'WO_PK'. Cannot
insert duplicate key in object 'WordOccurrences'.































































                  New to ADSelfService Plus?