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?

Henrootje wrote:
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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On 18 Okt., 17:21, Henrootje <Hen... (AT) gmail (DOT) com> wrote:
If I remember correctly you need to create ODBC connection and use it
for VISIO.
However my experience with VISIO was absolute failure. Stupid tool,
cannot understand simple constructions (were they arcs, connnot
remember on the spot), has various editions (professional, enterprise,
probably more), you'll never know which to use, one of them could
reverse engineer but copuld not generate scripts (BAHHH!!!!), creating
diagrams there isn't possibility to resize tables (or at least I could
not find it), overall net conclusion for me was - if one has 3 tables
with 2 realationships and few columns then probably this tool is OK

Gints Plivna
http://www.gplivna.eu

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 (DOT) org> wrote:

Henrootje wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

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 (DOT) org> wrote:

"Henrootje" <HenroV (AT) gmail (DOT) com> schreef in bericht
news:1193132330.337060.160580 (AT) i13g2000prf (DOT) googlegroups.com...
Henrootje,

please do not top post, some people around here don't like that (I couldn't
care less though).

Since you are a student, and don't have to use the tools commercially, you
could use Oracle Designer. It's free for you.....
but installing and using it isn't very straight forward.

Shakespeare

Henrootje wrote:
One of the tools I've used in the past is Happy Fish (weird name...).
You can find this tool here:

http://www.polderij.nl/happyfish/

The tool is not free, but it is relatively inexpensive.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

"Brian Peasland" <dba (AT) nospam (DOT) peasland.net> schreef in bericht
news:471dfb7b$0$26455$88260bb3 (AT) free (DOT) teranews.com...
I wonder how a tool can create an ERD from a database, since the steps from
ERD to Datamodel are not 1 on 1..... Some decisions like resolving arcs, m-n
relationships, (de)normalization etc will "disappear" in the process.

<quote>
Happy Fish combines ERD design with live database access to query or
maintain an already developed database.
<end quote>

I think they confuse an ERD with a Data Model Diagram....

Still looks useful though......

Shakespeare
(What's in an ERD?)

On Oct 23, 8:59 am, "Shakespeare" <what... (AT) xs4all (DOT) nl> wrote:
And other things will mysteriously appear, for example, constraints
between relationships. ("What's not in an ERD", so to speak).

I think that's all just showing the limitations inherent in moving
from design to implementation, then going into reverse. If you have
something poorly designed and/or implemented, there's going to be some
real doozies. For ongoing maintenance, there's going to be a need for
this type of tool, regardless. The more automated it can be, and the
bigger the system, the more helpful. If reversing into design can't
be made to work, that's a good sign to junk it all and start over.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/firemap/