Restore Data from MYSQL to MSSQL
Please Help:
I am getting the following output and error when trying to restore data into the MS SQL Server:
C:\AdventNet\ME\ServiceDesk\bin>restoreData
********************************************************************************
*
Restore DB Setup Wizard
********************************************************************************
*
Execute Restore DB Utility from command prompt
For Windows users :
bin>restoreData -c [backup file]
For Linux users :
bin]#sh restoreData.sh -c [backup file]
********************************************************************************
*
You chose to open this file: C:\AdventNet\ME\ServiceDesk\backup\Backup_sdp_6000_
03_06_2007_15_02.data
File name is : C:\AdventNet\ME\ServiceDesk\backup\Backup_sdp_6000_03_06_2007_15
_02.data
requestScheme is http
Please wait extracting backup file
Mar 6, 2007 3:56:17 PM com.adventnet.j2ee.deployment.service.internal.JarExtract
or extract
INFO: Extraction for C:\AdventNet\ME\ServiceDesk\backup\Backup_sdp_6000_03_06_20
07_15_02.data to C:\AdventNet\ME\ServiceDesk\bin\..
XLS = C:\AdventNet\ME\ServiceDesk\bin\..\server\default\deploy\mssql-ds.xml
properties = {Password=123456, DriverClass=net.sourceforge.jtds.jdbc.Driver, Us
erName=sa, ConnectionURL=jdbc:jtds:sqlserver://localhost:1107;DatabaseName=servi
cedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;}
Database username : sa
Database password : 123456
Database driver : net.sourceforge.jtds.jdbc.Driver
Database connectionProp : null
Database connectionURL : jdbc:jtds:sqlserver://localhost:1107;DatabaseName=servi
cedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;
Database started
*************************************************************
Backpup data : Tue Mar 06 15:02:20 EST 2007
Database name : servicedesk
Total Tables : 683
Build Number : 6000
*************************************************************
Mar 6, 2007 3:58:05 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: rootDir :: ..
Mar 6, 2007 3:58:05 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: netutilsData :: {RELEASE={version=6.0.0}, BUILD={number=6000}}
Mar 6, 2007 3:58:05 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=AdventNet Manage
Engine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
=====================================================
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
==========================java.sql.SQLException: Invalid SQL statement or JDBC e
scape, terminating ''' not found.
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1155)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156)
at net.sourceforge.jtds.jdbc.JtdsStatement.addBatch(JtdsStatement.java:1
088)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:240)
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$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Invalid SQL statement or JDBC escape, terminating '
'' not found.
C:\AdventNet\ME\ServiceDesk\bin>
New to ADSelfService Plus?