Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any way to auto update stored procedure from sql files ?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01015686
Message ID:
01016251
Vues:
12
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform