Posted by Erland Sommarskog on 12/23/05 10:20

laurenq uantrell (laurenquantrell@hotmail.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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]