469,090 Members | 1,203 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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

Dec 23 '05 #1
3 1254
laurenq uantrell (la*************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 23 '05 #2
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!

Dec 24 '05 #3
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!

Dec 24 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by DarkSpy | last post: by
205 posts views Thread by Jeremy Siek | last post: by
1 post views Thread by Do Park via SQLMonster.com | last post: by
6 posts views Thread by maricel | last post: by
5 posts views Thread by David | last post: by
1 post views Thread by chaitu | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.