@ECHO OFF
@REM
@REM $Id: //websites/unixwiz/unixwiz.net/webroot/evo/clickrestore.cmd#8 $
@REM
@REM Written by : Stephen J. Friedl
@REM              Software Consultant
@REM              Southern California USA
@REM              http://unixwiz.net/evo/clickrestore.html
@REM
@REM
@REM This simple program is attached to the ".gbk" handler 
@REM in Explorer, and it makes it easy to upload a new SYSTEM
@REM file to Evolution.
@REM
@REM We expect to be running *in* the directory with the SYSTEM.gbk
@REM file, and the target database (with hostname!) is required.
@REM
@REM Note: this was updated for Plymouth by using SYSDBA instead
@REM of EUSER
@REM

set TARGET=%1%

set SOURCE=SYSTEM.gbk
set CREDS=-user SYSDBA -pas pps97

if "%TARGET%"=="" (
  echo ERROR: missing target system parameter
  goto done
)

if not exist %SOURCE% (
  echo ERROR: %SOURCE% file not found
  goto done
)

echo.
echo Unixwiz.net clickrestore - restore Evolution SYSTEM database
echo.
echo Source: %CD%\%SOURCE%
echo Target: %TARGET%
echo.
echo [control-C to abandon]
echo.

pause
echo on
gbak -rep %CREDS% -page_size 8192 %SOURCE% %TARGET%

@echo off
SET EVOVER=C:\bin\evover.sql

IF EXIST %EVOVER% isql %CREDS% -i %EVOVER% %TARGET%

echo.

:done
pause