Re: Reverse engineering: ERwin\ERX

In article au0_at_hsc.usc.edu, mcitron_at_hsc.usc.edu (Mark Citron) writes:
>In article <mdayton.26_at_stpaul.ncr.com> mdayton_at_stpaul.ncr.com (Mike Dayton) writes:
>>Can anyone recomend a reverse engineering tool that
>>will produce a graphical representation of a data
>>schema from either SQL Scripts or an existing
>>Oracle 6 database?
>>I understand that Logic Work's ERwin\ERX product
>>has this capability.
>>email: Mike.Dayton_at_StPaul.NCR.COM | St. Paul, MN. 55113
>
>We use this tool and it does a nice job. It really wants to use sql
>scripts but you can hack an export file and make it use that.
>
>By the way, we also have Oracle's CASE and have not gotten nearly
>that far. It seems particularly difficult to use it with exisiting
>databases. I have not found a way to even get an entity relationship
>diagram from it based on an exisiting db.
>
IMHO it is a shortcoming of the current Oracle tools that they don't support a table diagrammer, consequently Designer is abused to serve this purpose. An entity relationship diagram is not a mere reflection of existing tables but a formal and abstract reflection of your enterprise, therefore reverse engineering existing tables into an ERD is challenging and in my experience often wrong. However I hear that the next release ofthe CASE tools will provide this capability. Anyone have any more on that?

Regards,
David TvE

---
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                           Sr. Systems Analyst
Motorola ASIC Division                            I don't speak for Mot.
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-