Friday, June 23, 2006

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:

Anonymous Michael Wilbon said...

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.

August 16, 2006 5:47:00 PM PDT  

Post a Comment

<< Home