azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

Database Diagram

Open kfish610 opened this issue 8 years ago • 42 comments

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

kfish610 avatar Nov 16 '17 19:11 kfish610

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

erickangMSFT avatar Dec 07 '17 17:12 erickangMSFT

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.

BrentOzar avatar Dec 07 '17 17:12 BrentOzar

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

kevcunnane avatar Dec 08 '17 21:12 kevcunnane

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

BrentOzar avatar Dec 09 '17 15:12 BrentOzar

Is extension supported yet?

IshamMohamed avatar May 11 '18 03:05 IshamMohamed

any update?

allanwei avatar Mar 22 '19 20:03 allanwei

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

JediSQL avatar Apr 22 '19 17:04 JediSQL

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

ScottSchwalm avatar Apr 30 '19 18:04 ScottSchwalm

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

JediSQL avatar May 01 '19 04:05 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.

JediSQL avatar May 01 '19 04:05 JediSQL

+1

sanan-fataliyev avatar Aug 31 '19 10:08 sanan-fataliyev

+1

mercuriete avatar Sep 26 '19 13:09 mercuriete

+1

ibrowne avatar Nov 13 '19 14:11 ibrowne

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

ghost avatar Dec 14 '19 15:12 ghost

@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.

mercuriete avatar Dec 14 '19 15:12 mercuriete

@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.

ghost avatar Dec 14 '19 19:12 ghost

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.

JediSQL avatar Dec 14 '19 19:12 JediSQL

@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.

kburtram avatar Dec 15 '19 01:12 kburtram

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...

Matteo-T avatar Dec 15 '19 01:12 Matteo-T

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

tomaztk avatar Jan 09 '20 09:01 tomaztk

+1

frosty-sh avatar Jan 16 '20 13:01 frosty-sh

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.

mercuriete avatar Jan 16 '20 14:01 mercuriete

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/

R0tenur avatar Feb 09 '20 12:02 R0tenur

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

fedelippo avatar Apr 09 '20 14:04 fedelippo

Please add!

bestickley avatar Aug 20 '20 13:08 bestickley

Would be very nice, even more if it allows IDEF1X

AdrianoAE avatar Nov 08 '20 11:11 AdrianoAE

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.

mouradbka avatar Dec 21 '20 09:12 mouradbka

Any progress?

AslanAmca avatar Dec 02 '21 15:12 AslanAmca

Any updates on this?

Az6bcn avatar Dec 06 '21 19:12 Az6bcn

Any update?

huy312100 avatar Jan 19 '22 13:01 huy312100