Comparing Database Diagrams

SeanEnnis

Is there a way to compare Database Diagrams yet?

I've found some discussion that Red Gate was working on it a couple years ago, but nothing recently.

Eddie D

Thank you for your forum post.

SQL Compare does not have this feature.

If this is a feature you would like to see added to SQL Compare, I recommend that create a post in the User Voice forum for SQL Compare using this LINK.

The more votes the request receives from other SQL Compare users it receives, better the chances you will see it in a future version of the product.

Many Thanks
Eddie

SeanEnnis

Done...

For the next guy, while we wait for it to make it to the top of the pile, here's what I did manually

UPDATE MyDB.dbo.sysdiagrams
SET definition = (
SELECT definition
from MyOtherDB.dbo.sysdiagrams
WHERE name = MyDB')
WHERE name = 'MyDB'

(that works on the same server - different servers may be more challenging)