Copy Stored Procedures from one server to another

I am moving a database from SQL Server 2005 to SQL Server 2005 Express
running on a laptop for a demo. I have the database tables and data copied,
but am unable to copy the stored procedures. How do I do this?
Thanks,
Mike Ober.
You can either use dts and the copy objects or use
a script like this:
generate script for stored procedures in dependency order
http://www.eggheadcafe.com/articles/20030609.asp
Robbe Morris - 2004-2006 Microsoft MVP C#
I've mapped the database to .NET class properties and methods to
implement an multi-layered object oriented environment for your
data access layer. Thus, you should rarely ever have to type the words
SqlCommand, SqlDataAdapter, or SqlConnection again.
http://www.eggheadcafe.com/articles/..._generator.asp
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>running on a laptop for a demo. I have the database tables and data
>copied, but am unable to copy the stored procedures. How do I do this?
> Thanks,
> Mike Ober.
>
|||The fastest way would be to detach the database copy the mdf and ldf files
to the laptop and attach them there.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>running on a laptop for a demo. I have the database tables and data
>copied, but am unable to copy the stored procedures. How do I do this?
> Thanks,
> Mike Ober.
>
|||Hi,
Take a look into the below URL; this talks about lots of options.
http://www.karaszi.com/SQLServer/inf...ate_script.asp
Thanks
Hari
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>running on a laptop for a demo. I have the database tables and data
>copied, but am unable to copy the stored procedures. How do I do this?
> Thanks,
> Mike Ober.
>
|||Hi
Open them in enterprise manager then "cut and paste" them to notepad
files.
Hope this helps
The Grand Master Programmer
Hari Prasad wrote:[vbcol=seagreen]
> Hi,
> Take a look into the below URL; this talks about lots of options.
> http://www.karaszi.com/SQLServer/inf...ate_script.asp
> Thanks
> Hari
>
> "Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
> news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
|||That worked - I had to delete and recreate the service account on the
laptop, but that wasn't a big deal.
Thanks,
Mike.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:%23CJI9xn5GHA.2524@.TK2MSFTNGP06.phx.gbl...
> The fastest way would be to detach the database copy the mdf and ldf files
> to the laptop and attach them there.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
> news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>
|||Robbe,
Thanks for the link to the adonet source code generator.
Mike Ober.
"Robbe Morris [C# MVP]" <joeblow@.joe.com> wrote in message
news:%23Ay1FQn5GHA.2292@.TK2MSFTNGP04.phx.gbl...
> You can either use dts and the copy objects or use
> a script like this:
> generate script for stored procedures in dependency order
> http://www.eggheadcafe.com/articles/20030609.asp
> --
> Robbe Morris - 2004-2006 Microsoft MVP C#
> I've mapped the database to .NET class properties and methods to
> implement an multi-layered object oriented environment for your
> data access layer. Thus, you should rarely ever have to type the words
> SqlCommand, SqlDataAdapter, or SqlConnection again.
> http://www.eggheadcafe.com/articles/..._generator.asp
>
>
> "Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
> news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>