Copying Stored procs in SQL Server 2005

How can I copy stored procs from a 2000 server to a 2005 server? The only
thing I see in the SQL SMS is copy the database which I'm having problems
with. In Ent Mgr 2000 when you export you could select SPs. I don't see that
option available in SMS.
Thanks for your help.Hi
You can try using a DTS package to transfer only the Stored Procedures.
Use the 'Copy SQL Server Objects Task' and choose your source / destination
SQL Servers and then under the copy tab select the objects that you want to
transfer.
You need to install the Data Transformation Services support [Integration
Services] on the SQL 2005 server and create the DTS package here. Since it is
backward compatible, I assume this will work.
Regards
Amer M J
MCP
"UJ" wrote:
> How can I copy stored procs from a 2000 server to a 2005 server? The only
> thing I see in the SQL SMS is copy the database which I'm having problems
> with. In Ent Mgr 2000 when you export you could select SPs. I don't see that
> option available in SMS.
> Thanks for your help.
>
>|||The cleanest way is to script out the sp's that you want in 2000 and run
that script in 2005. To get the script right click the db in EM and select
All Tasks - Generate Script. Then select the sp's you want.
--
Andrew J. Kelly SQL MVP
"UJ" <fred@.nowhere.com> wrote in message
news:%232rCEI9BGHA.1676@.TK2MSFTNGP09.phx.gbl...
> How can I copy stored procs from a 2000 server to a 2005 server? The only
> thing I see in the SQL SMS is copy the database which I'm having problems
> with. In Ent Mgr 2000 when you export you could select SPs. I don't see
> that option available in SMS.
> Thanks for your help.
>|||Where do I find the 'Copy SQL Server Objects Task' ?
"Amer M J" <AmerMJ@.discussions.microsoft.com> wrote in message
news:877834F8-0B0E-4982-B506-370C67D51E72@.microsoft.com...
> Hi
> You can try using a DTS package to transfer only the Stored Procedures.
> Use the 'Copy SQL Server Objects Task' and choose your source /
> destination
> SQL Servers and then under the copy tab select the objects that you want
> to
> transfer.
> You need to install the Data Transformation Services support [Integration
> Services] on the SQL 2005 server and create the DTS package here. Since it
> is
> backward compatible, I assume this will work.
> Regards
> Amer M J
> MCP
> "UJ" wrote:
>> How can I copy stored procs from a 2000 server to a 2005 server? The only
>> thing I see in the SQL SMS is copy the database which I'm having problems
>> with. In Ent Mgr 2000 when you export you could select SPs. I don't see
>> that
>> option available in SMS.
>> Thanks for your help.
>>|||That is all fine, but what is the proper way to do this in 2005 without
reverting back to DTS? Isnt DTS being depreciated anyway? Why isnt it as easy
as the old "import data" option in 2000? I am definately frustrated with SMS
2005 so far because I can't find a way to do the most simple things like
copying tables and procs between servers...
"Andrew J. Kelly" wrote:
> The cleanest way is to script out the sp's that you want in 2000 and run
> that script in 2005. To get the script right click the db in EM and select
> All Tasks - Generate Script. Then select the sp's you want.
> --
> Andrew J. Kelly SQL MVP
>
> "UJ" <fred@.nowhere.com> wrote in message
> news:%232rCEI9BGHA.1676@.TK2MSFTNGP09.phx.gbl...
> > How can I copy stored procs from a 2000 server to a 2005 server? The only
> > thing I see in the SQL SMS is copy the database which I'm having problems
> > with. In Ent Mgr 2000 when you export you could select SPs. I don't see
> > that option available in SMS.
> >
> > Thanks for your help.
> >
> >
>
>sql