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.
SET definition = (
WHERE name = MyDB')
WHERE name = 'MyDB'
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
Also, I would be nice to have SQL Source backup Database Diagrams and SQL Doc exporting them into the documentation.