Solved

Database relationship generator

Posted on 2009-04-10
6
558 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
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL tables, .net application and ETL connundrum 3 53
Question about DB Schema 27 52
performance query 4 20
SQL Query assistance 16 21
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

785 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