# Copying Live Vantage to Training DB 4.0

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-09-21 11:50 UTC
**Views:** 363
**Replies:** 0
**URL:** https://www.epiusers.help/t/copying-live-vantage-to-training-db-4-0/1182

---

## Post #1 by @system

<div id="ygrps-yiv-1914601935">In 4.0 I run these 2 bat files to copy the live &quot;production database &quot; to<br/>
the training database.<br/>
<br/>
Make sure that the training database is turned off before running the 2nd<br/>
bat file.<br/>
<br/>
The 2 bat files are located in the &quot;Epicor&quot; folder<br/>
<br/>
First File NAME  -   Step 1 Live Copy.bat<br/>
<br/>
REM      COPY THE LIVE PRODUCTION DB TO BACKUP&#92;TEMPDB<br/>
REM  ***ENSURE THAT TRAINING DB IS OFF LINE !!!!  ****<br/>
<br/>
PAUSE<br/>
CD V:&#92;EPICOR&#92;PROGRESS&#92;BIN<br/>
probkup online V:&#92;EPICOR&#92;VANTAGE&#92;DB&#92;VANTAGE V:&#92;EPICOR&#92;backup&#92;tempdb<br/>
<br/>
<br/>
Second File NAME  -   Step 2 Live Copy.bat<br/>
<br/>
REM      Restore BACKUP&#92;TEMPDB to VNTGTRN&#92;DB&#92;VANTAGE<br/>
REM  ***ENSURE THAT TRAINING DB IS OFF LINE !!!!  ****<br/>
<br/>
PAUSE<br/>
CD V:&#92;EPICOR&#92;PROGRESS&#92;BIN<br/>
call prorest V:&#92;EPICOR&#92;vntgtrn&#92;DB&#92;VANTAGE V:&#92;EPICOR&#92;backup&#92;tempdb<br/>
pause<br/>
<br/>
<br/>
The 1st bat file makes a backup copy of the live database and in my case<br/>
puts it in a folder called backup<br/>
<br/>
The 2nd bat file takes the backup copy and restores it over the training<br/>
database.<br/>
<br/>
I have not figured out how to make it all happen in a single bat file but<br/>
I&#39;m sure it must be possible<br/>
<br/>
Hope this helps.<br/>
<br/>
Regards,<br/>
<br/>
Jerry L. Solobay<br/>
Ebco Aerospace</div>

---


**Canonical:** https://www.epiusers.help/t/copying-live-vantage-to-training-db-4-0/1182
**Original content:** https://www.epiusers.help/t/copying-live-vantage-to-training-db-4-0/1182