Skip to content
← SQL Compare

How can we improve SQL Compare?

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Compare (and migrate) Database Diagrams

I'd love to see a function in SQL Compare to compare and migrate Database Diagrams. Especially between servers, but certainly on the same server.

We use them all the time to work on the structure of the of our databases and I'd love to be able to see the same diagram when I'm working in Prod and Test as I do in Dev without having to bring the changes across manually.

The code (for the easy case) is pretty simple.

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

17 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Sean Ennis shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    Looks like this suggestion has been here for a long time. Hopefully it'll get implemented some day!

    Need to be able to:

    1. Compare diagrams.
    2. Source-control diagrams.
    3. Optionally exclude diagrams from deployment scripts.

  • Anthony Baratta commented  ·   ·  Report

    Also, I would be nice to have SQL Source backup Database Diagrams and SQL Doc exporting them into the documentation.