Re: Reverse engineering existing remote Oracle 9i DB?

Visio is fine for quick n' dirty but, if you intend to do any real data modeling, spend the $ on a tool that was designed for that purpose. It is nice to have a data model repository when you deal with many different models from different applications. For example, defining enterprise-wide domains becomes much less cumbersome if you use a tool designed for that sort of thing. i.e.: Every application in your company tracks customer data--why not define the customer entity once and reuse the definition in every system?

I have never used Oracle Designer. I have used PowerDesigner and Erwin, and have played with Embarcadero's ERStudio. I like PowerDesigner the best of the three. Erwin is good but I just can't get past the lack of an "undo"! ERStudio is also very good but the repository is a separate product (more $).

"Andrew" <myfam_at_surfeu.fi> wrote in message news:c5826e91.0301240753.2fd32b48_at_posting.google.com...
> "JustAnotherDBA" <jadba_at_bellsouth.net> wrote in message
news:<u95Y9.11910$t51.2631_at_news.bellsouth.net>...
> > We have used Oracle Designer and it is a great product that does a LOT .
> >
> > If all you want to do is reverse engineer, VISIO does a fairly good job
of
> > reverse engineering Oracle and other databases . The "Professional
Edition"
> > might be needed for this feature and a couple of years ago cost less
than
> > $200, I think.
> >
> > I can't believe I just recommended a M$ product - I must need sleep...
> >
> Hi, Thanks for answer! In fact I have VISIO Prof. installed. It has
> some ODBC drivers (Miscrosoft ODBC Oracle and Oracle ODBC driver). Is
> it possible to connect VISIO to my Oracle 9i instance?
Received on Fri Jan 24 2003 - 12:26:00 CST