How to migrate stored procedures between SQL 2005?

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

Try the easy answer first: Any reason that you cannot use "Generate Scripts" from SSMS?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

JamieX Hall of Fame Points: 3763 More actions · Answer 2

I usually do what rbarryyoung says

But if you are deploying to many servers frequently, you can consider an SSIS package.

Use the Transfer SQL Server Objects Task. You can specify which objects to copy to what databases.

Then slap that in an foreach loop using this technique