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? :)
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
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.
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.
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...
5 comments:
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? :)
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!
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.
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.
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...
Post a Comment