Solved

Database relationship generator

Posted on 2009-04-10
6
574 Views
Last Modified: 2012-05-06
Lets say you have a Microsoft SQL database or MySQL database and there is no relationship diagram for the database.  Is there a tool out there that would read the database and generate a relationship diagram of the database.

0
Comment
Question by:stargateatlantis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 200 total points
ID: 24117852
The relationship diagram simply reads foreign keys in the db...which YOU would have to define.  So, there is really nothing that can be 100% accurate by reading field names, and assuming things and creating the foreign keys for you.  Does that make sense?
0
 
LVL 22

Assisted Solution

by:dportas
dportas earned 200 total points
ID: 24118001
Assuming you have foreign keys in your database then all the good data modelling tools will reverse-engineer it for you and produce a diagram. That includes Microsoft Visio, ER Win, Sybase Power Designer, Embarcadero E/R Studio, etc.
0
 

Author Comment

by:stargateatlantis
ID: 24118054
so visio can read a Microsoft SQL database and generate the the diagram?  It has all the foreign keys etc
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 200 total points
ID: 24118075
Sure, so long as the FKeys are defined, there are a lot of tools that can read them.  Visio is one of them.
As I was getting at...there isn't anything that can go in and define the Fkeys for you...but many apps can read the Fkeys (as david mentioned)
0
 
LVL 22

Assisted Solution

by:dportas
dportas earned 200 total points
ID: 24118130
>> so visio can read a Microsoft SQL database and generate the the diagram?
Yes. You need the Pro or Architect edition of Visio as I recall. I forget which.
0
 
LVL 30

Assisted Solution

by:Scott Helmers
Scott Helmers earned 100 total points
ID: 24122507
Actually, to reverse engineer an existing database, as you want to do, Visio should work fine. It's going the opposite direction -- creating database tables from a database model in Visio -- that require the special Visio for Software Architects product that dportas referred to above.

There is additional information about reverse engineering a database, including a couple of useful links, here:
   http://www.experts-exchange.com/Microsoft/Applications/Microsoft_Visio/Q_23773964.html

Scott
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question