Running SQL commands through a batch file.

[YL5956]

I was wondering if anyone know how to update tables or run stored procedures through the command prompt or batch file. Does anyone have sample code? We are implementing version controls through a third party vendor. This application will take any SQL Server updates including tables loads, storing new procedures etc through a batch file. How can this be accomplished in terms of invoking SQL Server through batch? Thanks in advance for any input.

 

[tlbroadbent]

Have you looked into the OSQL command line utility? It can run from a command line, and executes individual queries or batches of queries from a file.

http://msdn.microsoft.com/library/en-us/coprompt/cp_osql_1wxl.asp

You might also want to consider SQL-DMO.

http://msdn.microsoft.com/library/en-us/sqldmo/dmoref_con01_2yi7.asp

http://msdn.microsoft.com/library/en-us/sqldmo/dmoref_con01_85f7.asp

http://msdn.microsoft.com/library/en-us/sqldmo/dmoref_con01_3vcj.asp

Search MSDN for more SQL-DMO info.

http://search.microsoft.com/us/dev/default.asp

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.