Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-08 : 07:36:14
|
| Brandon writes "At work all our deployment is done Tivioli. This requires me to write .bat files to deploy any applications or updates. I need to deploy 50+ stores procedures to multiple SQL 200 servers using a bat file. I have looked at the osql and isql statements to do this and maybe I am missing something but I have been unable to fgure out how. Any advice or help would be greatly appreciated?Thank youBrandon" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-09-08 : 09:53:37
|
| The isql/osql executables allow you to pass dml/ddl from a file to sql server for execution. So you would create a .sql file with the 50+ CREATE PROCEDURE statements and run it through isql/osql on the command line as part of your batch file.Jonathan{0} |
 |
|
|
|
|
|
Inserting Stored Procedures with the command prompt