Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

Database Diagrams

Please add Database Diagrams back in SQL SERVER Management Studio

66 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

45 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Mike Malter commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please bring back database diagram support in SSMS 18.1. One of the reasons Microsoft database is popular its easy to modify data structure.

  • Paulo Planez commented  ·   ·  Flag as inappropriate

    How about add into sql server a partitioning resource that would allow to create a partition by any column of the table?

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Glad it's back but any diagrams created with V18 will not open again once SSMS is closed. Older diagrams are good.

  • Aan Dahliansyah commented  ·   ·  Flag as inappropriate

    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.

← Previous 1 3

SQL Server: Suggestions

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice