Copying Live Vantage to Training DB 4.0

Yahoo Archive
1
In 4.0 I run these 2 bat files to copy the live "production database " to
the training database.

Make sure that the training database is turned off before running the 2nd
bat file.

The 2 bat files are located in the "Epicor" folder

First File NAME - Step 1 Live Copy.bat

REM COPY THE LIVE PRODUCTION DB TO BACKUP\TEMPDB
REM ***ENSURE THAT TRAINING DB IS OFF LINE !!!! ****

PAUSE
CD V:\EPICOR\PROGRESS\BIN
probkup online V:\EPICOR\VANTAGE\DB\VANTAGE V:\EPICOR\backup\tempdb


Second File NAME - Step 2 Live Copy.bat

REM Restore BACKUP\TEMPDB to VNTGTRN\DB\VANTAGE
REM ***ENSURE THAT TRAINING DB IS OFF LINE !!!! ****

PAUSE
CD V:\EPICOR\PROGRESS\BIN
call prorest V:\EPICOR\vntgtrn\DB\VANTAGE V:\EPICOR\backup\tempdb
pause


The 1st bat file makes a backup copy of the live database and in my case
puts it in a folder called backup

The 2nd bat file takes the backup copy and restores it over the training
database.

I have not figured out how to make it all happen in a single bat file but
I'm sure it must be possible

Hope this helps.

Regards,

Jerry L. Solobay
Ebco Aerospace