Shell Programming and Scripting

SETLOCAL  	
REM execute merged script into DB
IF "%EnvName%"=="DEV" (
echo This is Dev

for /f "tokens=2 delims=^=" %%l in ('findstr "Server_%EnvName%" "%~dp0%configFilePath%"') do (
SET serv=!serv!%%l
echo "Server Name !serv!"
)

for /f "tokens=2 delims=^=" %%m in ('findstr "User_%EnvName%" "%~dp0%configFilePath%"') do (
SET usrName=!usrName!%%m
echo "USER Name !usrName!"
)

for /f "tokens=2 delims=^=" %%n in ('findstr "Pwd_%EnvName%" "%~dp0%configFilePath%"') do (
SET pwd=!pwd!%%n
echo "Password !pwd!"
)

for /f "tokens=2 delims=^=" %%n in ('findstr "DB_%EnvName%" "%~dp0%configFilePath%"') do (
SET db=!db!%%n
echo "Database !db!"
)

rem Execute for ddldml scripts first then SP.
sqlcmd -S !serv! -U !usrName! -P !pwd! -d !db! -i "%~dp0SourceCode\Output\MergedDDLAndDMLFile.sql"
sqlcmd -S !serv! -U !usrName! -P !pwd! -d !db! -i "%~dp0SourceCode\Output\MergedStoredProcs_!stamp!.sql"
echo SQLCommend ended successfully.
endlocal

if [ "$EnvName" = "Dev" ]
then
    echo "This is Dev"
fi

usrName=$(grep "User_$EnvName=" "$configFilePath" | cut -d= -f2)
[ -n "$usrName" ] && echo "USER Name $usrName"

Server_Dev=mydevbox
User_Dev=Alice
DB_Dev=devDB

Server_Live=mylivebox
User_Live=Bob
DB_Live=liveDB