@echo off

rem $Id: restoreData.bat,v 1.11.4.2 2007/06/15 06:17:40 kmurugesan Exp $

rem Please ensure that JAVA_HOME environment variable is pointing to a JDK/JRE.

call .\setcommonenv.bat
set SERVER_HOME=..

rem Setup the JVM
if "%JAVA_HOME%" == "" goto SET_DEF_JAVA

set JAVA=%JAVA_HOME%\bin\java
goto EXEC_TOOL

:SET_DEF_JAVA
set JAVA=java

:EXEC_TOOL
set DRIVER_CLASSES=%SERVER_HOME%\server\default\lib\mysql_connector.jar;%SERVER_HOME%\server\default\lib\jtds-1.2.jar
set CLASS_PATH=%SERVER_HOME%\server\default\lib\AdventNetPersistence.jar;%SERVER_HOME%\server\default\deploy\jboss-jca.sar;%DRIVER_CLASSES%;%SERVER_HOME%\server\default\lib\AdventNetDeploymentManager.jar;%SERVER_HOME%\server\default\lib\SDUtils.jar;%SERVER_HOME%\lib\jboss-common.jar;%SERVER_HOME%\server\default\lib\AdventNetFramework.jar;%SERVER_HOME%\lib\startupclasses.jar;%SERVER_HOME%\server\default\deploy\jbossweb-tomcat50.sar\commons-httpclient-3.0-rc1.jar;%SERVER_HOME%\server\default\deploy\jbossweb-tomcat50.sar\commons-codec-1.3.jar;%SERVER_HOME%\server\default\lib\commons-logging-1.0.2.jar

set JAVA_OPTS=-Ddb.home=%DB_HOME%

set JAVA_OPTS=%JAVA_OPTS% -Djboss.home.dir=%SERVER_HOME%  -Dfile.encoding=utf8

rem %JAVA%  %JAVA_OPTS% -cp %CLASS_PATH% com.adventnet.servicedesk.tools.RestoreDialog -c [backup_file]
%JAVA%  %JAVA_OPTS% -Xms128m -Xmx512m -cp %CLASS_PATH% -Dsdp.restore.error.ignoretables=softwarelist com.adventnet.servicedesk.tools.RestoreDialog %1 %2

rem How to ignore error table - please refer the below one
rem %JAVA%  %JAVA_OPTS% -Xms128m -Xmx512m -cp %CLASS_PATH% -Dsdp.restore.error.ignoretables=aaauser,sduser com.adventnet.servicedesk.tools.RestoreDialog %1 %2
rem How to speed up the restore progress - please refer the below one [default buffer size is 10 kb]
rem %JAVA%  %JAVA_OPTS% -cp %CLASS_PATH% -Dsdp.restore.buffersize_kb=10 com.adventnet.servicedesk.tools.RestoreDialog %1 %2