Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 593
  • Last Modified:

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.

0
stargateatlantis
Asked:
stargateatlantis
5 Solutions
 
chapmandewCommented:
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
 
dportasCommented:
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
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
chapmandewCommented:
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
 
dportasCommented:
>> 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 HelmersVisio 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now