Re: How to DTS SQL Files to update Procs?
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: Fri, 9 Apr 2004 08:50:41 +0100
OK so from what you mention you want to keep SPs on one system in sync with
the SPs on another. You can easily do this using SQLDMO. You would script
them out to text file, change the CREATE to ALTER and then replay the file
using OSQL (Look in BOL)
-- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "JDP@Work" <JPGMTNoSpam@sbcglobal.net> wrote in message news:%23xYUmbaHEHA.2580@TK2MSFTNGP12.phx.gbl... > If there is an easier way, please advise. > > Here's what I want to do. > > Say I have 30 stored procedures that I want to be sure are up to date and expect > changes to in the development system. I then want to update in the live system. > > I'm happy going thru the scripts one at a time as needed, and I'm confident that > no changes have been made in the dev system, but not in production where there > are many hands turning the handles. > > So, I would like to create a folder called "Finals" that is sub to the stored > proc's folder. > > I'd like to read each proc found in the folder and run them to update all 30 > procs in one step via DTS. > > What components do I need? > > For example I'm thinking that I need FSO, but I'm stummed at the next steps, > starting with how to read an SQL file and execute it. > > TIA > > JeffP... > >