批处理SQL 文件

@echo off
rem Input Parameters:
rem 1 -Server Name
rem 2 -Database Name
if "%1"=="" goto ERROR
if "%2"=="" goto ERROR
@rem Make variables local
@Setlocal
@rem set variables from input parameters
set Server=% 1
set DBName=% 2
@rem---------------------------------------------------------------
set LOGFILE=buildDB.log
rem---------------------------------------------------------------
if exist %LOGFILE% del %LOGFILE%
echo--------------------BEGIN %0 -------------------------------------
time/t
echo -----------------BEGIN %0---------------->>%LOGFILE%
time/t>>%LOGFILE%
@rem Create Database
echo Create Database
echo Create Database>>%LOGFILE%
osql -S %Server% -d master -i createdatabase.sql -n -b -w2048>>%LOGFILE%
@rem Create Tables
echo Create Tables
echo Create Tables>>%LOGFILE%
for % %i in(Table\*.sql) do call :osql "% %i"
@rem Create Constraints
echo Create Constraints
echo Create Constraints>>%LOGFILE%
for % %i in(Table\Constraints\*.sql) do call :osql "% %i"
@rem Create Triggers
echo Create Triggers
echo Create Triggers>>%LOGFILE%
for % %i in(Table\Triggers\*.sql) do call :osql "% %i"
@rem Create Indexes
echo Create Indexes
echo Create Indexes>>%LOGFILE%
for % %i in(Table\Indexes\*.sql) do call :osql "% %i"
@rem Create Views
echo Create Views
echo Create Views>>%LOGFILE%
for % %i in(Table\Views\*.sql) do call :osql "% %i"
@rem Create SPs
echo Create SPs
echo Create SPs>>%LOGFILE%
for % %i in(Table\SPs\*.sql) do call :osql "% %i"
@rem Create Functions
echo Create Functions
echo Create Functions>>%LOGFILE%
for % %i in(Table\Functions\*.sql) do call :osql "% %i"
goto DONE
:ERROR
Echo All 2 parameters (Server name ,CMDB database name) must be supplied as parameters.
Echo---------------------------------------------------------
Echo USAGE: %0 [Server] [database]
Echo------------------------------------------------------------
:ERROREXIT
echo-----