Batch file for new database

Hey,

Here is a sample one (assuming you're progress), ignore the parts on shutting the appsevers as you won't need it:

@REM These values are the only ones that need to be edited
@REM ======================================================

@REM Description of directories for editing
@REM --------------------------------------
@REM DLC: Should be your OpenEdge 10B directory
@REM epicordir: Should be your Epicor SystemAdmin directory
@REM dbdir: Should be your Vantage Database directory
@REM dbbkupdir: Should be your Vantage database backup directory

@set DLC=D:\epicor\oe101b
@set epicordir=D:\epicor\systemadmin
@set dbdir=E:\dbs\v803
@set dbbkupdir=E:\dbs_bkup

@REM ======================================================================
@REM Start the LIVE to PILOT copy
@REM ======================================================================

@REM Sets up your Windows path directory
@set PATH=%PATH%;%DLC%;%DLC%\bin

@echo =============================
@echo WARNING!!! LIVE TO PILOT COPY
@echo =============================
@echo This will delete all data in the PILOT system
@echo and copy the LIVE database to the PILOT system.
@echo (From last nights LIVE backup)
@echo Your PILOT system will be down during this time
@echo Your LIVE system will be unaffected.
@echo =============================
@echo If you are sure you want to do this, type "y"
@echo If you NOT wish to proceed, type "n"
@set /p yesno=Are you sure you want to do this? (y="yes",n="no"):

@if "%yesno%" NEQ "y" goto end

@echo -------------------------
@echo Shutdown PILOT appservers
@echo -------------------------
call asbman -name MfgPilot80 -kill
call asbman -name MfgPilot80ProcessServer -kill
call asbman -name MfgPilot80TaskAgent -kill

@REM Pause 30 seconds
%epicordir%\winsleep 30

@echo -----------------------------------------
@echo Shutting down PILOT DB (takes 30 seconds)
@echo -----------------------------------------
call dbman -stop -database mfgpilot80

@REM Pause 30 seconds
%epicordir%\winsleep 30

@echo ------------------------------------------------
@echo Copying LIVE to PILOT (can take about 5 minutes)
@echo ------------------------------------------------
@REM call prodel %dbdir%\pilot\mfgsys
call prorest %dbdir%\pilot\mfgsys %dbbkupdir%\live\mfgsys.bak < %dbdir%\bin\yesfile.txt
call prostrct list %dbdir%\pilot\mfgsys

@echo ------------------------------------------
@echo Starting PILOT database (takes 30 seconds)
@echo ------------------------------------------
call dbman -start -database mfgpilot80

@REM Pause 30 seconds
%epicordir%\winsleep 30

@echo -------------------------
@echo Starting PILOT AppServers
@echo -------------------------
call asbman -name MfgPilot80 -start
call asbman -name MfgPilot80ProcessServer -start
call asbman -name MfgPilot80TaskAgent -start

@echo Copy complete. If there are any errors please contact an administrator

@:end
@endlocal
@pause

--- In vantage@yahoogroups.com, warren klug <pirateofthemagothy@...> wrote:
>
> I want to run an offline Corvu reporting server and would like to upload the daily Progress backup to a reporting server that will run my daily reports. Can anyone offer suggestions for a batch file that will:
> 1. Â retrieve the nightly Vantage 6.1 backup when it completes
> 2. stop the database on the reporting server
> 3. restore the database on the reporting server
> 4. start the database on teh reporting server
> Â
> Once complete I can then launch the nightly Corvu scheduler and not interfere with all of my China users coming into the system.Â
> Â
> Thanks,
> Warren Klug
> Lion BrothersÂ
>
> [Non-text portions of this message have been removed]
>
I want to run an offline Corvu reporting server and would like to upload the daily Progress backup to a reporting server that will run my daily reports. Can anyone offer suggestions for a batch file that will:
1. Â retrieve the nightly Vantage 6.1 backup when it completes
2. stop the database on the reporting server
3. restore the database on the reporting server
4. start the database on teh reporting server
Â
Once complete I can then launch the nightly Corvu scheduler and not interfere with all of my China users coming into the system.Â
Â
Thanks,
Warren Klug
Lion BrothersÂ

[Non-text portions of this message have been removed]