Database relationship generator

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.

stargateatlantisAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
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
 
dportasConnect With a Mentor Commented:
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
 
stargateatlantisAuthor Commented:
so visio can read a Microsoft SQL database and generate the the diagram?  It has all the foreign keys etc
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
chapmandewConnect With a Mentor Commented:
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
 
dportasConnect With a Mentor Commented:
>> 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
 
Scott HelmersConnect With a Mentor Visio Consultant, Trainer, Author, and DeveloperCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.