Server Group Deployment

• arrjay

  Hall of Fame

  Points: 3455

  More actions

  October 28, 2014 at 4:31 am

  #294575

  Hi All- I need to run a piece of code against 50 databases, each on separate SQL servers - Pretty daunting task! - The database name with always be the same but the servers names will be different. This is going to be a common exercise in the future therefore I want to develop/download a program to manage this requirement in an automated fashion. Does anyone know of anything/any advice they can kindly hand over. Thanks!

  --------------------------------------------

  Laughing in the face of contention...

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 28, 2014 at 4:49 am

  #1755158

  Powershell could be the right tool for this job.

  See an example here: http://sethusrinivasan.wordpress.com/2012/01/11/powershell-script-to-run-query-against-many-servers-and-send-combined-output-as-email/

  -- Gianluca Sartori