Deploy multiple db scripts to multiple servers
After doing some code cleanup on some stored procedures, I needed a efficient way to deploy the scripts to multiple servers/databases. I had 20 different scripts and though that is not a huge amount I still wasn't looking forward to opening each file in Query Analyzer and executing for each server. Google saves the day again and led me to a DOS command that fit the bill perfectly. (Note that if you run the command from within a .bat file you should specify %%variable instead of %variable)

1 Comments:
You have interesting comments. However, there is no information on your website as to what is the purpose of your website. What is it? Who is Phil Cruz? What are his credentials or experience in this field? There is no information on your website as to how you can be contacted. How can we contact you or your company for more information? thank you.
Post a Comment
<< Home