ServiceDesk Unable to restore data from MySQL to MSSQL
Hi,
I am facing problem to restore data of ServiceDesk Plus from MySQL data backup to MS SQL 2012 / 2014.
I received the following error message. Hope someone can assist.
java.sql.SQLException: Cannot alter 'trace_xe_event_map' because it is not a table.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1120)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1073)
at com.adventnet.servicedesk.tools.RestoreSDBackup.deleteTableData(RestoreSDBackup.java:658)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:139)
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 : Cannot alter 'trace_xe_event_map' because it is not a table.