Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2009-02-12 : 11:38:40
|
| I have around 1000 SQL instances across the country. And there are frequent large code deployments. What are the best practices? Does anyone uses any tools? ------------------------I think, therefore I am - Rene Descartes |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-02-12 : 13:37:41
|
| We began using Automated QA for deployments. It works pretty well. There are plenty of similar tools on the market, as well. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2009-02-12 : 14:21:43
|
| Thank you, mcrowley.------------------------I think, therefore I am - Rene Descartes |
|
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-02-13 : 08:57:26
|
| You can implement such abitlity using bat files calling for sqlcmd on each server. You can also write a simple application that uses xml as deployment configuration complemented with a folder of scriptsThanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
|
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-02-16 : 05:05:08
|
| http://db-staff.com/index.php/microsoft-sql-server/85-multiple-server-script-executelook through this article if you are interested in using sqlcmd for deploymentThanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
|
|
|
|
|
|
SQL Server code deployment.