Re: Visio and Oracle?

Henrootje wrote:
> It is Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production.
>
> I understand Visio is not very good for the tasks I mentioned. Maybe
> suggestions for other free toils?
> Preferably a tool that can talk to MySQL as wel......
>
> TIA,
>
> Henro
>
>
> On 18 okt, 17:09, DA Morgan <damor..._at_psoug.org> wrote:

>> Henrootje wrote:
>>> Can anyone tell me how I can reverse engineer an Oracle database from
>>> Visio Professional 2003?
>>> I am running a Oracle 9 database, just installed the 10g Oracle Client
>>> on Vista but I simply cannot connect....
>>> Oracle keeps whining about the tnsnames.ora file which it keeps
>>> telling me it can't parse.................
>>> Suggestions?
>> Unless your database contains nothing but heap tables and B*Tree
>> indexes it can not be done. Visio is a brain-dead tool barely able
>> to support SQL Server. Try to get Visio to recognize a sequence
>> object, or an object view, or just about anything else and you are
>> doomed to failure.
>>
>> PS: There is no such thing as "Oracle 9." Is it 9.0.1 or 9.2.0.8?
>> It matters in almost all cases.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

Visio is free?

There are no good free tools that do ERDs. There are a lot of lousy tools that do a poor job and only with basic object and column types. If you want something decent you will need to open your wallet.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org