Wednesday, February 15, 2012

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,
lq1. use the DTS Wizard and specify the "Copy Objects and Data between
SQL Server databases and then select the stored procedures you want to
export.

2. Script up a file by (right) clicking on the appropiate database or
the individual procedure and Select "Generate SQL Script"

HTH, Jens Suessmeyer.|||Jens, Thanks. I didn't see that option for some reason.
This has made recovery much simpler.
lq

No comments:

Post a Comment