8/22/2016

Schema Compare multiple databases at once...

Post moved to:

schema-compare-multiple-databases-at-once

Thanks!

5 comments:

h.a.! said...

Thanks for the write-up. Reading the title of your article, I got excited thinking this would be a Red-Gate SQL Compare like GUI where I could see a visual representation of schema differences... That would be like asking for fries wouldn't it? :)

Kevin said...

Actually, SQL Server Data Tools Schema compare does have a very similar GUI to the RedGate SQL Compare, with lots and lots of ways to fine-tune your comparison. But...nothing for selecting multiple targets at once....thus, this post :D

Thanks for reading!

Anonymous said...

I have not had time to try your process, but it looks like it will be very handy. We are always finding clients that have missing tables, missing columns, missing - fill in the blanks. And as a side note, Apex has a free Refactor tool that integrates with SSMS that you can customize. I am constantly sent SQL that came from a third party reporting tool and it is a jumbled mess.

Klatnu Veradida said...

Perhaps something here will jump start my thinking on how to accomplish the same thing in an all-Azure SQL Database world across many distinct databases, across many Azure servers, in different elastic pools.

Kevin said...

Maybe if you maintain some table of all the connection properties for each database you can use that to generate the same statements I did. After all, each statement is just feeding a source "gold" db and a target server/db combination...