Compare Prod vs Dev all dbs

Answers

• Pete_Ruiz Redgate › Posts: 123 Silver 4

  November 7, 2019 6:45PM

  Hello @MikeM
  

  
  

  Thanks for reaching out. Unfortunately, this isn't something SQL Compare is able to do and I'm not aware of an available tool that can do this. However, you might be able to accomplish this using a batch file or PowerShell script perhaps that will run a compare for all your databases from dev to prod one after another.

  
  

  I hope this helps. Please let me know if there are any further questions.
  

  
  

  Kind regards,
  

  
  

  Pete Ruiz
  

  0 · Share on Twitter
• MikeM Posts: 6 New member

  November 7, 2019 6:52PM

  Thanks for the response!
  With that being the case, I am glad I didn't go looking too much. I am working on a batch file solution and will provide that to the forum if it works out.

  0 · Share on Twitter
• David Atkinson Redgate › Posts: 1,462 Rose Gold 2

  November 7, 2019 8:50PM

  I haven't tried it, but as Peter implies, PowerShell should be able to start multiple jobs in parallel. Maybe this helps: https://stackoverflow.com/questions/4016451/can-powershell-run-commands-in-parallel

  David Atkinson
  Product Manager
  Redgate Software

  0 · Share on Twitter
• Pete_Ruiz Redgate › Posts: 123 Silver 4

  November 8, 2019 4:19PM

  Hello @MikeM ,

  
  

  Would love to hear back from you on how it goes. Good luck!

  
  

  Cheers,
  

  
  

  Pete Ruiz
  

  0 · Share on Twitter