How to copy stored procedures between database?

[MarkB2]

Using a stored procedure how do I copy stored procedures from one database to another?

This would be done weekly and so an automated way is what I am looking for. I would also have to drop them from the target database if appropriate.

TIA
Mark

 

[SQLSister]

Look at SQLCompare (

http://www.red-gate.com),

it will let you compare db objects and script out the differences.

Questions about posting. See faq183-874