|
Home > Archive > Microsoft SQL Server forum > December 2005 > Export SPs?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| laurenq uantrell 2005-12-23, 3:24 am |
| 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
| |
| Erland Sommarskog 2005-12-23, 3:24 am |
| 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
| |
| laurenq uantrell 2005-12-23, 8:24 pm |
| 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!
| |
| laurenq uantrell 2005-12-23, 8:24 pm |
| 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!
|
|
|
|
|