Database Diagram

[kfish610]

Some form of Database Diagram, similar to SSMS, would make using this much easier and enjoyable.

[erickangMSFT]

[help wanted] Is anyone willing to build an extension for database diagram?

[BrentOzar]

When you say extension, would this be something that would be a part of this Github repo? If so, probably need to address the #102 licensing issue first before you accept code contributions.

[kevcunnane]

@BrentOzar no, extensions can develop outside this repo and use their own licensing. We plan to support extension installation in a future release.

[BrentOzar]

@kevcunnane WOOHOO! That's so awesome to hear. Thanks, sir.

[IshamMohamed]

Is extension supported yet?

[allanwei]

any update?

[JediSQL]

With database diagrams being removed from SSMS (SQL Server Management Studio) 18, someone should put a roaring fire under this.

[ScottSchwalm]

I agree with @JediSQL. The priority on this should be moved towards the top of the pile with database diagrams removed from SSMS 18.

[JediSQL]

Suggestion 1: Per the agile paradigm, build the reverse engineering mode first; add forward engineering later.

[JediSQL]

Suggestion 2: It would be cool to have a feature that could, at least, read existing diagrams out of the sysdiagrams table. I've spent countless hours creating diagrams to support the developers that work with my databases.

[sanan-fataliyev]

+1

[mercuriete]

+1

[ibrowne]

+1

[waynebloss]

@JediSQL I just installed SSMS v18.4 and diagrams are there.

[mercuriete]

@waynebloss did you install azuredatastudio?
SSMS is another diferent program.
This is a feature request for azure data studio.
Sorry if I am saying something obvious.

[waynebloss]

@mercuriete I was responding to JediSQL who said "With database diagrams being removed from SSMS (SQL Server Management Studio) 18..."

I was simply correcting the information.

[JediSQL]

The original Microsoft documentation for removal of database diagrams from SSMS (SQL Server Management Studio) 18 said that it was deprecated. I think that someone got carried away and mistook deprecated for discontinued and removed it from SSMS 18. So, Microsoft is probably still planning on removing diagrams from a future version of SSMS.

[kburtram]

@JediSQL @waynebloss previously Database Diagrams was planned for removal from SSMS and was not included in 18.0. It turns out customers actually like and use this feature 😄 so @Matteo-T added it back in a subsequent 18.# release. I don't think there are currently any plans to remove diagrams from a future SSMS version as far as I'm aware.

[Matteo-T]

That is correct, @kburtram. Sadly, though, the Database Diagram is not fully functional at the moment. I've been trying to get it fix for quite some time now...

[tomaztk]

Please add Database Diagram to Azure data studio, similar to the one in SSMS. Thank you

[frosty-sh]

+1

[mercuriete]

Please, it doesnt need to be fancy.

Something like graphviz -> SVG

In the end we only need tables and relations in a graph.

First iteration could be graphviz -> SVG only table names and relations.
something like: http://viz-js.com/
as azuredatastudio is open we can rely in another opensource projects.

[R0tenur]

I´ve built an extention for this. It doesn´t have that many features yet, but try it out if you are interested.

Here is the repo: https://github.com/R0tenur/visualization/

You can install from vsix downloaded here: https://github.com/R0tenur/visualization/releases/

[fedelippo]

Please add an Entity Relationship Diagram tool to Azure data studio.

[bestickley]

Please add!

[AdrianoAE]

Would be very nice, even more if it allows IDEF1X

[mouradbka]

vsix

I´ve built an extention for this. It doesn´t have that many features yet, but try it out if you are interested.

Here is the repo: https://github.com/R0tenur/visualization/

You can install from vsix downloaded here: https://github.com/R0tenur/visualization/releases/

it worked great for me, thank you very much! I struggled a bit to install extension on azure data studio. What finally worked for me was to download the folder and then "file > install Extension from VSIX Package" and had to reload ADS and now it works seamlessly.

[AslanAmca]

Any progress?

[Az6bcn]

Any updates on this?

[huy312100]

Any update?

[JediSQL]

Looking @"Matteo-T commented on Dec 14, 2019" I get the impression that SSMS is where MSFT is putting their DB diagrams effort for the time being.

[Az6bcn]

Any updates on this?

[prajun7]

Still waiting

[diablo2947]

This would be a great help. Diagrams are really helpful in explaining the schema to people who are new on a project

[ederbond]

+1 - And please use a modern look and fell. I mean, thin lines and scalable vector images.
Something similar to this would be awesome:
https://www.devart.com/dbforge/sql/studio/sql-server-database-designer.html

[soumesh2002]

+1... It's been 2024 and there's no support for creating ER Diagram in Azure Data Studio officially. Hope in 2024 there will be support for creating ER Diagram.