June 1, 2011 at 10:28 pm
Hello every one, I have a small question. I have some stored procs like 25-30. I need to alter them and deploy to other environments...manually running these stored procs on all environment is some what difficult, i need to run each and every sps for all environments...Is there any way that i can do it automatically all at once? plese help me am new to sql server. Thanks in advance
June 2, 2011 at 12:53 am
Hi
Generate the script file using Generate scripts option. Then execute that sql file in required areas.
Regards
Siva Kumar J
June 3, 2011 at 9:55 pm
Thanks for responding....Can you tell me how to generate script? Thanks
June 5, 2011 at 9:49 am
Hi
Go to SSMS
select the required db from databases
rightclick->Tasks->Generate Scripts
set true/false for required options
then select required tables/functions/procedures
save the results to a script to file/script to query window/script to clipboard.
Then copy the script and run it in wherever you require.
Regards
Siva Kumar J.
June 5, 2011 at 9:57 am
Once you have the script, you can use SQLCMD to deploy it to all your environments, or if you can group connect to the required instances ( SSMS registered servers tree) do it that way.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply