Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any way to auto update stored procedure from sql files ?
Message
 
To
19/05/2005 23:16:23
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01015686
Message ID:
01016251
Views:
11
Virusim,

I personally use Visual Source Safe, but I have also used CVS.... You might have a couple of options, depending on what you want to do. You can use osql from the command line (can be batched in a batch or a vbs cmd file) or you could use an ODBC connection and pass the sql script as a commandtext - it would look something like (pseudo code):

baseDir="C:\MyScripts"
for each file in baseDir
if right(filename,4)=".sql" then
cmdexec osql filename - look at books online for all options
end if
next

Let me know if this points you in the right direction.

-R!
Ricardo A. Parodi
eSolar, Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform