How do I - Export Stored Procedures in SQL 2005

18 Aug 2006 4:53 PM

Curtis

I have recently upgraded to SQL 2005 and have not found a tool for exporting
stored procedures from a source server to a destination server. In SQL 2000
this tool was in the export feature and it seem MS has removed the copy
object tool from the export feature.

Any ideas?

18 Aug 2006 5:54 PM

Tibor Karaszi

I believe that this functionality is exposed in Integration Services now. It has been removed (for
some reason) from the other Import/Export wizards.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Curtis" <gilbertson.cur***@leg.wa.gov> wrote in message
news:%234ipebuwGHA.4944@TK2MSFTNGP02.phx.gbl...
>I have recently upgraded to SQL 2005 and have not found a tool for exporting stored procedures from
>a source server to a destination server. In SQL 2000 this tool was in the export feature and it
>seem MS has removed the copy object tool from the export feature.
>
> Any ideas?
>

18 Aug 2006 8:53 PM

Keith Kratochvil

You can right-click on a database
Choose Tasks | Generate Scripts
Wade through the various screens
When you get to "Choose Object Types" you will want to select Stored
Procedures

--
Keith Kratochvil

Show quote

"Curtis" <gilbertson.cur***@leg.wa.gov> wrote in message
news:%234ipebuwGHA.4944@TK2MSFTNGP02.phx.gbl...
>I have recently upgraded to SQL 2005 and have not found a tool for
>exporting stored procedures from a source server to a destination server.
>In SQL 2000 this tool was in the export feature and it seem MS has removed
>the copy object tool from the export feature.
>
> Any ideas?
>