Compare Prod vs Dev all dbs

MikeM

I have many dbs on dev and prod and need to compare them all at once (schema not data). SQLCompare only allows one at a time. I looked at using command line, but haven't had enough time to work through that as a solution. Anyone have a multi-compare solution that is slick?

Pete_Ruiz

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

MikeM

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.

David Atkinson

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

Pete_Ruiz

Hello @MikeM ,

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

Cheers,

Pete Ruiz