Failed migration to MSSQL

Failed migration to MSSQL

Version is 7.0.12.

Installation was made on mysql.
I've created backup, then executed changeDBServer.bat and changed engine to mssql.
After that SD service was started and stopped.

When I've tried to restore data from backup I have an error:

Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
============================================QUERY = INSERT INTO task_input (INST
ANCE_ID,SCHEDULE_ID,WORKFLOW_TEMPLATE_ID,SCHEDULE_TIME,EXECUTION_START_TIME,EXEC
UTION_FINISH_TIME,WORKENGINE_ID,ADMIN_STATUS,OPERATIONAL_STATUS,SERVER_ID,CRID)
VALUESnull
java.sql.BatchUpdateException: Data truncation
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:84)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Data truncation
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:84)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Data truncation

Any ideas? Is this path for migration still valid for SD 7?







































                  New to ADSelfService Plus?