:: Tested on Win7 and Sql Server 2008

:: THIS SCRIPT GOES TO ALL SUBFOLDERS AND RUNS THE

:: YOU NEED THE FOLLOWING FOLDER STRUCTURE:

:: ROOT - THIS IS WHERE THIS FILE IS + THE FOLLOWING SUBFOLDERS

:: --0.BackUp

:: --1.Mixed

:: --2.Tables

:: --3.StoredProcedures

:: --4.Triggers

:: --5.RollBack

@ECHO OFF

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 RUNNING %%i1>>"..\install.log"&SQLCMD -U userName -P Password -H hostname -d DBNAME -t 30 -w 80 -u -p 1 -b -i %%i -r1 1>> "..\install.log" 2>> "..\error.log"

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 D:\DATA\BACKUPS

ECHO CLICK A KEY TO CONTINUE

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

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 RUNNING %%i1>>"..\install.log"&SQLCMD -U userName -P Password -H hostname -d DBNAME -t 30 -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 RUNNING %%i1>>"..\install.log"&SQLCMD -U userName -P Password -H hostname -d DBNAME -t 30 -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 stored procedures

CD ".\3.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 RUNNING %%i1>>"..\install.log"&SQLCMD -U userName -P Password -H hostname -d DBNAME -t 30 -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 ".\4.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 RUNNING %%i1>>"..\install.log"&SQLCMD -U userName -P Password -H hostname -d DBNAME -t 30 -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

cmd /c start /max INSTALL.LOG

CMD /C start /MAX ERROR.LOG

echo DONE !!!

ECHO HIT A KEY TO EXIT

pause