@Echo off

REM BAT file is in scheduler but it is disabled because it is not running.....

REM This BAT resides in:
REM	PROD	\\[ProdFoundationServer]\d$\oracle\middleware\user_projects\epmsystem1\import_export\all-backup
REM
REM logs are in D:\Oracle\Middleware\user_projects\[ProdFoundationServer]\diagnostics\logs\sharedservices
REM             D:\Oracle\Middleware\user_projects\[ProdFoundationServer]\diagnostics\logs\migration  
REM             D:\Oracle\Middleware\user_projects\[ProdFoundationServer]\diagnostics\logs\essbase\lcm
REM
REM PART A: LCM extracts
REM 		1. create folder
REM 		2. execute LCM utility
REM 		3. ZIP extract
REM 		4. XCOPy to QA server
REM PART B: HFM Taskflow extracts are generated by scheduled jobs
REM		1. map qa server and create destination folder
REM		2. zip extracts
REM		3. xcopy zip to QA server
REM PART C: Essbase extract
REM PART D: FDM extract
REM
REM Warning: if the ADMIN password is changed, the migration definition xml files need to be updated.
REM          The PW will be encrypted after the first run of the utility.

cd /D d:\oracle\middleware\user_projects\[ProdFoundationServer]\import_export\all-backup

for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set year=%%c
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set month=%%a
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set day=%%b

REM ==== now lets make a directory with the date in it

md %year%-%month%-%day%

set bkfile=LCM-PROD-%year%-%month%-%day%.7z
set bkfile1=HFM-PROD-%year%-%month%-%day%.7z
set bkfile2=Essbase-PROD-%year%-%month%-%day%.7z
set bkfile3=FDM-PROD-%year%-%month%-%day%.7z

REM                     output is in folder names backup_...

SET backup_folder="d:\oracle\middleware\user_projects\[ProdFoundationServer]\import_export\all-backup\%year%-%month%-%day%"


:PARTA
REM ==== execute LCM utility

cd ..\..\bin

SET migrationdefinitionfile=d:\oracle\middleware\user_projects\[ProdFoundationServer]\import_export\all-backup\prodmigrdef_essbase.xml
call utility.bat %migrationdefinitionfile% -b %backup_folder%

SET migrationdefinitionfile=d:\oracle\middleware\user_projects\[ProdFoundationServer]\import_export\all-backup\prodmigrdef_foundation.xml
call utility.bat %migrationdefinitionfile% -b %backup_folder%

SET migrationdefinitionfile=d:\oracle\middleware\user_projects\[ProdFoundationServer]\import_export\all-backup\prodmigrdef_PLN.xml
call utility.bat %migrationdefinitionfile% -b %backup_folder%

SET migrationdefinitionfile=d:\oracle\middleware\user_projects\[ProdFoundationServer]\import_export\all-backup\prodmigrdef_Reports.xml
call utility.bat %migrationdefinitionfile% -b %backup_folder%

SET migrationdefinitionfile=d:\oracle\middleware\user_projects\[ProdFoundationServer]\import_export\all-backup\prodmigrdef_HFM.xml
call utility.bat %migrationdefinitionfile% -b %backup_folder%

REM ==== now zip all extracts

cd ..\import_export
cd all-backup\%year%-%month%-%day%

d:\7-zip\7z.exe a -t7z %bkfile% backup*

REM ==== now go to archive destination in QA

NET USE Q: \\[QAserver]\import_export\all-backup
Q:
md PROD-Bkup-%year%-%month%-%day%
cd..

REM ==== now copy zip file to the other env

d:
copy %bkfile% q:\PROD-Bkup-%year%-%month%-%day% 

REM ==== back to import_export folder

cd ..\..

:PARTB

REM ==== go to folder that holds taskflow extracts d:\oracle\middleware\user_projects\epmsystem1\import_export\

cd hfmbackup
del *.7z
d:\7-zip\7z.exe a -t7z %bkfile1% *

copy %bkfile1% q:\PROD-Bkup-%year%-%month%-%day% 

REM ==== back to import_export folder

cd ..

:PARTC

:END
REM Disconnect mapped network drive

NET USE Q: /d