Re: Creating entity relationship diagrams from Oracle database

> "Brian M. Biggs" <bbiggs_at_cincom.com> writes:
> Is there a simple tool available for importing the Oracle data
> dictionary information and constructing an entity relationship diagram
> for a set of tables?
 < snip>
> Brian M. Biggs mailto:bbiggs_at_cincom.com
> Cincom Systems, Inc. voice: (513) 677-7661
> http://www.cincom.com/
>

>>>>
Brian,

I assume you've already looked at Oracle's own tool (Designer/2000), right? It allows you to Reverse Engineer the physical database, and then Retrofit the table/constraint/index/etc. definitions into a Logical Data Model (aka entity relationship diagram aka 'what you wanted').

If the reason you *didn't* mention it was because you had looked at it and discarded it (for whatever reason) as an option, there are other tools (i.e. LogicWork's ER/win product); but having worked with Designer/2000 for a while now, I'd have to recommend it as the tool of choice in your case (especially because the data is in an Oracle RDBMS to begin with).

Regards,
Gary Wong (gary.wong_at_cyberstore.ca)
Information Technology Consultant
(604) 360-1699 (Voice)
(604) 384-1178 (Fax) Received on Thu Jan 11 1996 - 00:00:00 CET