Re: Oracle Database Schema Diagram Generator
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 18 Sep 2009 17:53:26 -0700
Message-ID: <4ab42b86$1_at_news.victoria.tc.ca>
Shakespeare (whatsin_at_xs4all.nl) wrote:
: Sashi schreef:
: > On Sep 18, 1:58 pm, Spiff McClure <sardonicstuffedti..._at_gmail.com>
: > wrote:
: >> I've been searching around and I'd like to know if anyone can
: >> recommend a decent tool to generate a Database Schema Diagram from an
: >> Oracle DB. I have an existing database that is very large and complex
: >> so generating a visual to explain it's current tables and their
: >> relationships would help a lot of people out.
: >>
: >> Free and open source tools preferred but I might be willing to use
: >> something else if the tools is good and highly recommended.
: >>
: >> Thanks
: >
: > I use Aqua Data Studio as a sql client and it has a useful diagram
: > generator. They do have a 30 day trial so you can try it out. I've
: > used this to generate diagrams and works ok. I'm not a picky and heavy
: > weight user so YMMV.
: > HTH,
: > Sashi
Date: 18 Sep 2009 17:53:26 -0700
Message-ID: <4ab42b86$1_at_news.victoria.tc.ca>
Shakespeare (whatsin_at_xs4all.nl) wrote:
: Sashi schreef:
: > On Sep 18, 1:58 pm, Spiff McClure <sardonicstuffedti..._at_gmail.com>
: > wrote:
: >> I've been searching around and I'd like to know if anyone can
: >> recommend a decent tool to generate a Database Schema Diagram from an
: >> Oracle DB. I have an existing database that is very large and complex
: >> so generating a visual to explain it's current tables and their
: >> relationships would help a lot of people out.
: >>
: >> Free and open source tools preferred but I might be willing to use
: >> something else if the tools is good and highly recommended.
: >>
: >> Thanks
: >
: > I use Aqua Data Studio as a sql client and it has a useful diagram
: > generator. They do have a 30 day trial so you can try it out. I've
: > used this to generate diagrams and works ok. I'm not a picky and heavy
: > weight user so YMMV.
: > HTH,
: > Sashi
: Oracle SQL Developer Data Modeler?
Graphviz to do the graphing.
The details for the graphing statements can be extracted from tables such as USER_CONS_COLUMNS. The graphviz dot language is extremely simple, you can get a basic graph with statements such as
DEPARTMENTS -> EMPLOYEES ; DEPARTMENTS -> LOCATIONS ; EMPLOYEES -> DEPARTMENTS ;
The "record" format is more involved, but can make nodes that look pretty much like a regular ERD. Received on Fri Sep 18 2009 - 19:53:26 CDT