How can we help you today? How can we help you today?

Compare Prod vs Dev all dbs

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?
MikeM
0

Comments

4 comments

Sort by
  • 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
    Pete_Ruiz
    0
  • 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.
    MikeM
    0
  • 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
    David Atkinson
    0
  • Pete_Ruiz
    Hello @MikeM ,

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

    Cheers,

    Pete Ruiz
    Pete_Ruiz
    0

Add comment

Please sign in to leave a comment.