I want to change db server from mysql to mssql, so :

-I installed new 7514 SDPserver

-select mssql db server (MSSQL2005)

-run run.bat (default DB create sucsesfull and all OK)

-restore backup from old SDP server  ver 7514 with mysql.

So I have error when restoring:

 Please wait ! Restoring in Progress...................
Error Tables : softwarelist
0-----------------------50------------------------100(%)
==================QUERY = INSERT INTO holidaydefinition (HOLIDAYDEFINITIONID,HOLIDAYDATE,DESCRIPTION,SITEID,ISRECURRING)
 VALUESnull
java.sql.BatchUpdateException: Data truncation
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:404)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:141)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:91)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:184)
        at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Data truncation
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:404)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:141)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:91)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:184)
        at java.lang.Thread.run(Unknown Source)
Unable to restore database : Data truncation

I attache my restoreData.bat. Early I have trouble with double entry in softwarelist table so it not default.

In that table (holidaydefinition) I have (#1-10) entries with "null" SITEID, and the same (#11-20) entry with SITEID "301". Maybe I need to delete row with null SITEID or ignore this table when restore in bat file.