only My site

Thursday, August 16, 2012

SQL Deployment using BAT file

SET username=USER_NAME
SET password=PASSWORD
SET dbname=DBNAME
SET servername=SERVER_NAME

sqlcmd -U %username%  -P %password%   -S %servername%  -d %dbname%  -i RequiredScript.sql   -o  SQLFILENAMEWITHPATH.txt

pause

No comments: