how to deploy stored procedures

Using SQL 2008 I have created four stored procedures and one view.
What is the equivalent of an install or reg-update for SQL?
I just want as simple a way as possible to make a package or something that can be moved and installed on x number of instances of this database.  Something one step above copy and paste would be good.
I have no experience in this field.  Any  suggestions?  Security is not a concern.
Who is Participating?
Scott PletcherSenior DBACommented:
In SQL 2008 SSMS, you can create a local server group with all the instances you need in it, then when you run the CREATE and other other statements, they all run against all of the instances automatically.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what about a batch job using SQLCMD tool to run a -sql file with the CREATE (or ALTER) scripts
Scott PletcherSenior DBACommented:

Sorry I didn't flesh that answer out, didn't have time then.

I'm guessing you researched it yourself :-) .

Just to be sure, in SQL 2008 SSMS, you create a Local Server Group(s), with any name(s) you want, under "Registered Servers" tab/task.

Then you right-click on the Group name, and select "New Query".  You code/paste your query in there, and when you run, it will automatically run against all instances in that group.

Pretty sweeeeet!!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.