:: START CMD FILE Deploy_DbName.cmd

:: DOCS AT THE EOF FILE 

@ECHO OFF

ECHO BEFORE PROCEEDING WITH DEPLOYMENT DID YOU ENSURE 

ECHO THAT YOU CHANGE THE CONFIGURATION ENTRIES IN THIS 

ECHO CMD FILE IF NOT PRESS CTRL + C AND EDIT THE FILE 

ECHO IF YES PRESS A KEY TO CONTINUE 

PAUSE

::CHANGE HERE THE APPROPRIATE VARIABLES 

SET DbName=DbName

::THIS IS WHERE THE DB FILES WILL BE SITUATED NOT THE \A AT THE END !!!

SET DataPath=D:\cas\Sql_dev\GenericSingleClickMsSqlDbDeployment\DATA\

:: CREATE THE DataPath DIRECTORY IF WE DO NOT HAVE IT 

MKDIR %DataPath%

::CHANGE HERE THE APPROPRIATE VARIABLES 

SET CurrentDate=%Date%

::the Configuration entry of the 

SET DbBackupsDirectory=D:\cas\Sql_dev\GenericSingleClickMsSqlDbDeployment\DbBackups\

:: CREATE THE DbBackupsDirectory DIRECTORY IF WE DO NOT HAVE IT 

MKDIR %DbBackupsDirectory%

ECHO CREATE FIRST BACKUP OF ALL DATABASES ON THE DEFAULT INSTANCE ONES: 

ECHO CREATING THE LOG FILES

echo THIS IS THE ERROR LOG OF THE UPDATE OF THE %DbName% ON %DATE% >error.log

echo THIS IS THE INSTALL LOG OF THE UPDATE OF THE %DbName% ON %DATE% >install.log

ECHO STARTTING BACKUP 

CD .\0.BackUp

ECHO FOR EACH SQL FILE DO RUN IT THIS WILL TAKE A WHILE 

ECHO SINCE WE ARE GOING TO MAKE A BACKUP FOR ALL THE DATABASES ON THE CURRENT HOST 

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -H hostname -d MASTER  -t 30000 -w 80 -u -p 1 -b -i %%i  -r1 1>> "..\install.log" 2>> "..\error.log" 

::PAUSE

ECHO GO ONE FOLDER UP 

ECHO SLEEP FOR 1 SECOND 

ping -n 1 127.0.0.1 >NUL

ECHO DONE WITH BACKUP GOING UP 

cd ..

ECHO THE BACKUPS ARE IN THE FOLDER

ECHO %DbBackupsDirectory%

ECHO CLICK A KEY TO CONTINUE

ECHO ========================================================================================================================

PAUSE

ECHO STARTING INSTALLING FUNCTIONS

CD ".\1.Functions"

ECHO FOR EACH SQL FILE DO RUN IT 

ping -n 1 127.0.0.1 >NUL

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -H hostname -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log" 

ECHO DONE WITH STORED PROCEDDURES GOING UP 

cd .. 

ping -n 1 127.0.0.1 >NUL 

ECHO HIT A KEY AFTER PAUSE 

PAUSE

ECHO START TO EXECUTE THE MIXED FILES

CD .\1.Mixed

ECHO CREATING THE LOG FILES

echo. >>"..\error.log"

echo. >>"..\install.log"

ECHO FOR EACH SQL FILE DO RUN IT 

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -H hostname -d %DbName% -t 3000 -w 80 -u -p 1 -b -i %%i  -r1 1>> "..\install.log" 2>> "..\error.log" 

ECHO GO ONE FOLDER UP 

cd ..

ECHO SLEEP FOR 1 SECOND 

ping -n 1 127.0.0.1 >NUL

ECHO DONE WITH MIXED GOING UP 

ECHO HIT A KEY AFTER PAUSE 

PAUSE

ECHO STARTING INSTALLING TABLES 

CD .\2.Tables

ECHO FOR EACH SQL FILE DO RUN IT 

ping -n 1 127.0.0.1 >NUL

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -H hostname -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log" 

ping -n 1 127.0.0.1 >NUL

ECHO DONE WITH TAbles GOING UP 

cd .. 

ping -n 1 127.0.0.1 >NUL 

ECHO HIT A KEY AFTER PAUSE 

PAUSE

ECHO STARTING INSTALLING Views

CD ".\3.Views"

ECHO FOR EACH SQL FILE DO RUN IT 

ping -n 1 127.0.0.1 >NUL

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -H hostname -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log" 

ECHO DONE WITH Views GOING UP 

cd .. 

ping -n 1 127.0.0.1 >NUL 

ECHO HIT A KEY AFTER PAUSE 

PAUSE

ECHO STARTING INSTALLING stored procedures

CD ".\5.StoredProcedures"

ECHO FOR EACH SQL FILE DO RUN IT 

ping -n 1 127.0.0.1 >NUL

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -H hostname -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log" 

ECHO DONE WITH STORED PROCEDDURES GOING UP 

cd .. 

ping -n 1 127.0.0.1 >NUL 

ECHO HIT A KEY AFTER PAUSE 

PAUSE

ECHO STARTING INSTALLING Triggers

CD ".\6.Triggers"

ECHO FOR EACH SQL FILE DO RUN IT 

ping -n 1 127.0.0.1 >NUL

for /f %%i  in ('dir *.SQL /s /b /o') DO ECHO   %DATE% --- %TIME% RUNNING  %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -H hostname -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i"  -r1 1>> "..\install.log" 2>> "..\error.log" 

ping -n 1 127.0.0.1 >NUL

ECHO DONE WITH Triggers GOING UP 

cd .. 

ping -n 1 127.0.0.1 >NUL 

ECHO HIT A KEY AFTER PAUSE 

PAUSE

ECHO Please , Review the log files and sent them back to Advanced Application Support 

set mailadd= yordan.georgiev^@consultingcompany.fi

:: WE USE THE "%cd%\bin\bmail.exe".EXE UTILITY TO SEND OURSELF AN E-MAIL CONTAINING THE TEXT FILE 

:: ALTERNATIVE SMTP MIGHT BE esebe107.NOE.company.com, UNCOMMENT THE NEXT LINE FOR ALTERN

::"%cd%\bin\bmail.exe" -s smtp.company.com -m install.log -t yordan.georgiev@consultingcompany.fi -a "POC 1.2 install log" -h

::"%cd%\bin\bmail.exe" -s smtp.company.com -m error.log -t yordan.georgiev@consultingcompany.fi -a "POC 1.2 error log" -h

CMD /c start /max INSTALL.LOG

CMD /C start /MAX ERROR.LOG

echo DONE !!!

ECHO HIT A KEY TO EXIT 

PAUSE

:: WE GO TROUGH ALL THE FOLDERS AND RUN THE SQL FILES IN ALPHABETIC ORDER 

:: START CMD FILE Deploy_DbName.cmd

:: PURPOSE : 

:: THIS FILE DOES RUN ALL SQL SCRIPT FILES IN ORDER TO DEPLOY THE DbName

:: DATABASE. 

:: ENVIRONMENT -- THIS SCRIPT NEEDS SQLCMD IN YOUR PATH + SQL SERVER 2005 / 2008

:: USAGE: EDIT THE CONFIGURATION ENTRIES AND DOUBLE CLICK. REVIEW THE