My turn to ask a simple [if not stupid] question, hopefully I'll be the benefactor of the Sergey encyclopedia....

There are a few dozen stored procs that I need to update from one database server to another [basically test and production]. What's the quickest and most painless way to refresh? I'm having a brain seizure right now. Thanks...

Kevin