Andrew wrote:
> "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?
Yes, Visio can connect to *any* ODBC-compliant database (Oracle, Sybase,
whatever) and "automatically" draw a diagram. If you have a very large
schema (lots of tables), you'll have to do quite a bit of juggling to
make your drawing readable (but you have to do that no matter what ERD
tool you're using). With the high-end, high-priced Visio Studio for
Enterprise Architects, you can change the model and forward engineer it
as well.
Received on Fri Jan 24 2003 - 10:49:25 CST
