Wednesday, February 27, 2013

create db objects via bat file


echo off
cls
echo.
echo =========================
echo CREATE NEW VIEWS ON DATABASE
echo =========================
echo.
echo.
echo.
echo Executing create...
sqlcmd -S . -E -i %~p0\v_x.sql -o %~p0\Log\CreateViewsLog.txt
echo.
%~p0\Log\Log.txt
echo Create View Executed!
echo Log saved on %~p0\Log\
echo.
pause


No comments: