Database Diagrams
Please add Database Diagrams back in SQL SERVER Management Studio
Anonymous
shared this idea
This was completed in SSMS 18.1.
Caveat: there is still a known issue where diagrams created from SSMS on machine A opened with SSMS running on machine B would cause SSMS to crash.
This has been reported already and it is being investigated (it is just not as simple as I would like to be).
Thanks,
-Matteo
45 comments
-
Mike Malter
commented
This should not be closed. It's still happening even with diagrams created with the latest version. After saving and then opening, SSMS crashes.
-
Stu Alderman
commented
Matteo, this has been going on way too long. Are you getting any help and resources from management? In my testing I can see it's a monster and very complex, unpredictable and hard to replicate problem. Anything I can do, or contribute, I'd be glad to help, but your management really ought to be throwing a whole lot of support in your direction.
-
Adailton Andrade
commented
Not only created on machine A and opened with SSMS running on machine B cause SSMS to crash, if I created a diagram on machine A, save, close SSMS, Open SSMS and try to open the diagram, the SSMS still crashing, please fix this.
-
Ken Keeton
commented
If I create a diagram and then the next day try to open it, SSMS will crash. Why can't they fix this?
-
Maurice Pelchat
commented
I just tried SSMS 18.3.1. It opens diagrams created from SSMS 17.9.1, open new diagrams created under SSMS 18.3.1. It doesn't open those created under SSMS 18.2 version. For me, this is not much an issue, since I could not make much database diagrams with version 18, so there is almost no work to recover from this.
-
Jon F
commented
Thanks for bringing this back, Matteo!!!
-
Juan Carlos
commented
Esta posibilidad de ver de otro angulo una base de datos descontractura el cerebro!
-
Guy Twena
commented
Great to have the Diagrams back.. now I can upgrade SSMS
-
ALOY Pascal
commented
Could you add sort and filter on the grid result in SSMS ?
Thx -
Anonymous
commented
Please bring back database diagram support in SSMS 18.1. One of the reasons Microsoft database is popular its easy to modify data structure.
-
Tomasz
commented
Microsoft, please bring back debugging in SSMS 18.1.
-
Paulo Planez
commented
How about add into sql server a partitioning resource that would allow to create a partition by any column of the table?
-
Ramiro
commented
I just installed back 17.9.1 for diagrams. Thank you for taking it back.
-
Anonymous
commented
Surely someone can download the table config in one query so it doesn't take forever!
We are in the internet age now.. Azure SQL anyone??
-
Kellie
commented
As Nick B reports, diagrams created with V18.1 won't open the next time SSMS is opened. Trying to open a diagram closes SSMS to close silently.
-
Nick B
commented
Glad it's back but any diagrams created with V18 will not open again once SSMS is closed. Older diagrams are good.
-
HollyP
commented
Please add back possibility to change names of each query tab.
Thanks. -
Aan Dahliansyah
commented
MICROSOFT, please don't EVER remove diagram support. It should be improved, not removed. I'm using SSMS since SQL 2000's era, and this is the best tool for updating table structure on-the-fly without having to create a temporary table. I'm not a database administrator, I'm an active developer. Creating and maintaining database structure is FAST using SSMS.
Thanks for bringing back this Feature.
-
Damon
commented
Good job.
-
MUSTAFA FADIL
commented
Please ... I need diagram for SSMS 8.1 ?