UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Ssms - Diagram Relationship Notation, Any Versions    
 
   
cheekybuddha
post May 22 2017, 06:05 AM
Post#1


UtterAccess VIP
Posts: 9,275
Joined: 6-December 03
From: Telegraph Hill


Hi all,

Is there any way in SSMS to show relationships between the actual related fields rather than join lines in the middle of each table box (much like in Access relationships view)?

tia,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
GroverParkGeorge
post May 22 2017, 06:47 AM
Post#2


UA Admin
Posts: 31,195
Joined: 20-June 02
From: Newcastle, WA


I believe not. However, you can hover the mouse over the relationship line to show a tool tip that identifies it.

Attached File  SSMSRelationships.png ( 23.08K )Number of downloads: 4

--------------------
Go to the top of the page
 
cheekybuddha
post May 22 2017, 07:10 AM
Post#3


UtterAccess VIP
Posts: 9,275
Joined: 6-December 03
From: Telegraph Hill


Thanks, George.

I suspected that the mouseover was the best there is.

Grrr!

d

--------------------


Regards,

David Marten
Go to the top of the page
 
cheekybuddha
post May 22 2017, 07:18 AM
Post#4


UtterAccess VIP
Posts: 9,275
Joined: 6-December 03
From: Telegraph Hill


It's a shame when you compare with MySQL Workbench!
Attached File(s)
Attached File  20170522_mysql_workbench_screenshot.png ( 326.03K )Number of downloads: 18
 

--------------------


Regards,

David Marten
Go to the top of the page
 
cheekybuddha
post May 22 2017, 07:21 AM
Post#5


UtterAccess VIP
Posts: 9,275
Joined: 6-December 03
From: Telegraph Hill


In SSMS, the mouseover only shows the table names, not even the related fields!

pullhair.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 
nvogel
post May 22 2017, 07:22 AM
Post#6



Posts: 811
Joined: 26-January 14
From: London, UK


SSMS relationships diagram is pretty poor for any serious data modelling in my opinion. Overall it is a bit better than the relationships diagram feature in Access, but not so much better. I would suggest you consider using a proper data modelling tool instead.
Go to the top of the page
 
cheekybuddha
post May 22 2017, 07:23 AM
Post#7


UtterAccess VIP
Posts: 9,275
Joined: 6-December 03
From: Telegraph Hill


Suggestions?

Preferably something free that can connect and reverse-engineer! wink.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 
nvogel
post May 22 2017, 08:19 AM
Post#8



Posts: 811
Joined: 26-January 14
From: London, UK


There is a whole list here. My current favourites are Sparx Enterprise Architect (cheap but powerful), Oracle SQL Data Modeler (free and it does support SQL Server as well). Unlike the SSMS and Access -based diagrams, these tools support actual ER modelling concepts and standard notation, forward engineering, reverse engineering and much more.
Go to the top of the page
 
GroverParkGeorge
post May 22 2017, 08:33 AM
Post#9


UA Admin
Posts: 31,195
Joined: 20-June 02
From: Newcastle, WA


Thanks for the references. I had wrongly been under the impression that management tools were specific to one DB. I think that's true for many?

--------------------
Go to the top of the page
 
cheekybuddha
post May 22 2017, 11:03 AM
Post#10


UtterAccess VIP
Posts: 9,275
Joined: 6-December 03
From: Telegraph Hill


Thanks for the list @nvogel.

While Barker and Bachman notations are more expressive in describing the joins, I miss the ability to see which fields are being joined at a glance.

In the end I plumbed for using DBeaver (not on the list) which I already had installed on my machine (I use linux).

It doesn't join the fields in the diagram, but when you click on the relationship line the related fields are highlighted, so next best thing!

thumbup.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 
haresfur
post Aug 3 2017, 11:40 PM
Post#11



Posts: 221
Joined: 4-April 12
From: Bendigo, Australia


You can click over the end of the line (Cursor will turn to a +) and then drag that up or down to the field you want. It's a bit of a pain - if you resize the box for a table the endpoint doesn't move properly although it will if you move the whole box. You can also drag the lines around and add bends in the middle of them.

--------------------
-- Evan
Go to the top of the page
 
MadPiet
post Aug 18 2017, 09:16 AM
Post#12



Posts: 2,255
Joined: 27-February 09



The thing that kills me is that Visio used to be able to do it, but MS killed that off. There was a Wizard, if I remember right (it was around 2002), and it would just suck all the info out of the database schema and build the ERD for you.
Go to the top of the page
 
haresfur
post Nov 23 2017, 08:49 PM
Post#13



Posts: 221
Joined: 4-April 12
From: Bendigo, Australia


I just discovered something that might help you when I was creating my first view in Management Studio. It threw all the tables into a quite decent looking diagram with the fields joined properly. Maybe you can create a view of your whole database that displays a better diagram. Haven't tested this.

Attached File  View.JPG ( 98.65K )Number of downloads: 4

--------------------
-- Evan
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 11:26 PM