Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Visio and Oracle?

Re: Visio and Oracle?

From: Henrootje <HenroV_at_gmail.com>
Date: Tue, 23 Oct 2007 09:38:50 -0000
Message-ID: <1193132330.337060.160580@i13g2000prf.googlegroups.com>


I did not say that Visio is free. I am legally using Visio, that is why I wanted to use it.
I am doing a degree in ICT (Bachelor of ICT) besides my job. One of the courses is desiging databases. That is why I want to analyze existing database structures.
But according to the reactions here Visio is not the right tool to do this.
Then I have to look for an alternative but budget is limited. I hoped there would be some tool(s) I could use to help me analyse existing databases.
If you know of any good tools, I would like to know which those would be. Maybe I can find some student licensing program. But since I just started things do no t need to be overly complicated. Is there anything you can point me too?

TIA, Henro

On 22 okt, 17:40, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Tue Oct 23 2007 - 04:38:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US