Home Forums SQL Server 2005 Development How to Execute *.sql scripts using SQLCMD in batch file format RE: How to Execute *.sql scripts using SQLCMD in batch file format

  • August 25, 2008 at 1:44 am

    #862407

    Thanks to All,

    Here is the solution

    >> "D:\ClearviewBuild\OutputofModifyDBandCreateSprocs.txt" Echo Running ModifyBuildQueueDB

    "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.exe" -i "D:\Build\Database\Modify Databases\ModifyCoreDatabase-5-0.sql" >> "D:\Build\OutputofModifyDBandCreateSprocs.txt"

    >> "D:\ClearviewBuild\OutputofModifyDBandCreateSprocs.txt" Echo *************************

    >> "D:\ClearviewBuild\OutputofModifyDBandCreateSprocs.txt" Echo *************************

    >> "D:\ClearviewBuild\OutputofModifyDBandCreateSprocs.txt" Echo Running AcreateAuditSprocs

    "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.exe" -i "D:\Build\Database\Create Sprocs\CreateAuditSprocs.sql" >> "D:\Build\OutputofModifyDBandCreateSprocs.txt"

    >> "D:\ClearviewBuild\OutputofModifyDBandCreateSprocs.txt" Echo *************************

    >> "D:\ClearviewBuild\OutputofModifyDBandCreateSprocs.txt" Echo *************************

    In Brief sqlcmd -i is the command for execting sql scripts and -q is the command line parameter to execte individual SQL Scripts

    Added some commenting lines to make the log look neat

    Thanks,

    Jerry