wilfordrocks
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!!