Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Export SPs?I have uses DTS Import/Export wizard to export all my tables from one databse to another on the same server. How do I export all of my stored procedures and UDFs? Thanks, lq
Post Follow-up to this message
Re: Export SPs?laurenq uantrell (laurenquantrell@hot mail.com) writes: > I have uses DTS Import/Export wizard to export all my tables from one > databse to another on the same server. How do I export all of my stored > procedures and UDFs? You keep your code under version control, and install them from them from that source. What's in the database, should be regarded as binaries in my opinion. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pr...oads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodin...ions/books.mspx
Post Follow-up to this message Re: Export SPs?Erland, I would love to be in the position to do it that way, but in this case, it's an inherited mess with stored procedures supporting literally a dozen different upgrade versions and a couple of platforms as well!
Post Follow-up to this message Re: Export SPs?Erland, I would love to be in the position to do it that way, but in this case, it's an inherited mess with stored procedures supporting literally a dozen different upgrade versions and a couple of platforms as well!
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
