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.
thanks
wilfordrocksAsked:
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.
0
 
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
http://msdn.microsoft.com/en-us/library/ms162773.aspx
0
 
Scott PletcherSenior DBACommented:
Thanks!

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!!

0
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.