Solved

ER Diagram Tool

Posted on 2014-03-07
12
570 Views
Last Modified: 2014-04-01
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
Comment
Question by:Star79
  • 3
  • 2
  • 2
  • +3
12 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 250 total points
ID: 39913475
Hi,

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

Regards
  David
0
 

Author Comment

by:Star79
ID: 39913505
David,
But it does not put the relationship on its own.
0
 
LVL 5

Assisted Solution

by:ina_don
ina_don earned 125 total points
ID: 39913577
If you don't hate having to run java then you can try http://sourceforge.net/projects/mogwai/
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 13

Expert Comment

by:magarity
ID: 39914071
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39914786
But it does not put the relationship on its own.
You are right.  No tool will add relationships that do not exist.
0
 
LVL 11

Expert Comment

by:b_levitt
ID: 39920949
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
 
LVL 13

Expert Comment

by:magarity
ID: 39921685
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
 
LVL 11

Expert Comment

by:b_levitt
ID: 39921716
@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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39922333
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
 

Author Comment

by:Star79
ID: 39924871
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
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 250 total points
ID: 39925169
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
 
LVL 13

Assisted Solution

by:magarity
magarity earned 125 total points
ID: 39928218
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 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