• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 584
  • Last Modified:

ER Diagram Tool

Is there any free tool that can produce the ER diagram from an existing database without me having to go through creating through visio or others.
0
Star79
Asked:
Star79
  • 3
  • 2
  • 2
  • +3
4 Solutions
 
David ToddSenior DBACommented:
Hi,

There is the SQL diagram within the database. Not sure how portable it is.

Regards
  David
0
 
Star79Author Commented:
David,
But it does not put the relationship on its own.
0
 
ina_donCommented:
If you don't hate having to run java then you can try http://sourceforge.net/projects/mogwai/
0
Technology Partners: 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!

 
magarityCommented:
David is referring to the 'create diagram' function of the SQL Server manager.  Yes, it does diagram the relationships but since you say it is not for you, your tables probably don't have enforced foreign key relationships already defined.  You can drag and drop between the tables in the diagram tool to make the relationships, save your diagram as an image, and then not save the changes to the database.  This is about your best choice I can think of.  Otherwise how would any other program know the relationships?  Do you have a test/development server where you can make an alternate copy of the database and put in the relationships for diagram purposes?
0
 
Anthony PerkinsCommented:
But it does not put the relationship on its own.
You are right.  No tool will add relationships that do not exist.
0
 
b_levittCommented:
I beleive Oracle's (yes irony) Data Modeler will do this via it's Import->Data Dictionary feature along with a jdbc connection to sql server.

http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

http://stackoverflow.com/questions/15267532/create-connection-to-sql-server-db-from-oracle-data-modeler
0
 
magarityCommented:
Sure, Oracle's data model will get foreign keys IF they're already defined.  The problem appears to be that they're not actually defined as constraints.
0
 
b_levittCommented:
@magarity - I didn't see the ops comment relating to automatically creating relationships.  For that I refer him to your answer ;) (how would it know?).  I can't think of ANY modeling tool that would create relationships based on naming alone
0
 
Anthony PerkinsCommented:
For that I refer him to your answer ;) (how would it know?).  
Exactly.

I can't think of ANY modeling tool that would create relationships based on naming alone
Nor I and more importantly would you even trust that tool if it existed.
0
 
Star79Author Commented:
Not sure whom to award the points as its clear that there is no tool which puts a diagram based on the naming. But yes SQL diagram will give me if there is FK constraints.
0
 
David ToddSenior DBACommented:
Hi,

I believe that Visio will do the relationship - if there are FK constraints.

And there is, or at least used to be, a version of Visio in the Enterprise Architect MSDN subscription, that could push changes into the database. That is, from changes made to the diagram, create the FK constraints.

HTH
  David
0
 
magarityCommented:
If you have a test/development server then you can use the diagram tool there to drag-n-drop FK's and save the resulting diagram.  This is reasonably easy. Although it will create the FK's in the database, which is why you should do it on a spare copy schema in test.
If you have heck a lot of tables then call your local community college's computer science department and get an intern to do it.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now