Friday, February 17, 2012

Copy stored procedures from 1 DB to another DB

I need to copy the stored procedures from a database on one server to another. I used 121 WAM to copy the DB tables over but don't know how to copy the stored procedures over.

Can someone point me in the right direction?

Ultimately, what I would like to do is have the 2nd server update from the 1st server so I can set up a redundant DB.

Thank you for your help in advance.

JoelUse DTS and "Copy Objects".

In Enterprise Manager, right-click on the database, in All Options, find Export.

No comments:

Post a Comment