We want to migrate our servicedesk plus database from postgres SQL to MSSQL.

 

The existing server is still a WinXP machine, with servicedesk plus on the latest version (build 9026).

We have also set up a new server (Win2008R2) with the same version (build 9026), and the DB configured on MSSQL.

 

While restoring the backup of the database of the old WinXP server into the new server on MSSQL, we encounter the following error:

 

Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
====================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)

Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
=========================QUERY = INSERT INTO SoftwareManufacturer (swmanufacture
rid,name,createdby,supportdeflicensetypes,description,logo) VALUES(6942, N'LoUck
yCoupon', NULL, '1', N'', N'sw-nologo.png');

java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'SoftwareManuf
acturer_UK1'. Cannot insert duplicate key in object 'dbo.SoftwareManufacturer'.
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:630)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:324)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:133)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:186)
        at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of UNIQUE KEY constraint 'SoftwareManufac
turer_UK1'. Cannot insert duplicate key in object 'dbo.SoftwareManufacturer'.
Violation of UNIQUE KEY constraint 'SoftwareManufacturer_UK1'. Cannot insert dup
licate key in object 'dbo.SoftwareManufacturer'.