sql*plus diagrams

[Betty]

I inherited a job that uses Oracle. There are maybe
90 tables. I have files that I can run through
sql*plus to create the tables so I have the descriptions.
Question is: is there any software that I can use
to make diagrams from these files, ERD or otherwise?

 

[Tor Iver Wilhelmsen]

Question is: is there any software that I can use
to make diagrams from these files, ERD or otherwise?

Once the database has been "generated" into a schema, you can use
software like CA's ERWin to extract a model/diagram, and/or convert to
other databases, redesign etc.

http://www3.ca.com/Solutions/Product.asp?ID=260

But what does that have to do with Java?

 

[Malte]

Once the database has been "generated" into a schema, you can use
software like CA's ERWin to extract a model/diagram, and/or convert to
other databases, redesign etc.

http://www3.ca.com/Solutions/Product.asp?ID=260

But what does that have to do with Java?

Oracle JDeveloper can do that, at least i can provide the class
diagrams. I am quite certain that Oracle Designer can do the same.

 

[Betty]

Once the database has been "generated" into a schema, you can use
software like CA's ERWin to extract a model/diagram, and/or convert to
other databases, redesign etc.

http://www3.ca.com/Solutions/Product.asp?ID=260

Thanks, but it is $3,995.

But what does that have to do with Java?

It is indirect, I access the database using Java programs.

 

[Bjorn Abelli]

...

Thanks, but it is $3,995.

I can recommend DBDesigner (GNU GPL), which has worked excellent when I've
been in a need for a quick ERD.

http://www.fabforce.net/dbdesigner4/

Though it's specially designed to work with MySQL, it can reverse engineer
from Oracle as well.


// Bjorn A

 

[gevatron]

Oracle JDeveloper that you can download free on OTN:
http://www.oracle.com/technology/products/jdev

Can reverse (and forward) engineer your DB structure into diagrams.
(and it can also create Java classes for these diagrams).

Check out the onlin demo here:
http://www.oracle.com/technology/products/jdev/viewlets/10g/DatabaseModeling_viewlet_swf.html

 

[Malte]

Oracle JDeveloper that you can download free on OTN:
http://www.oracle.com/technology/products/jdev

Can reverse (and forward) engineer your DB structure into diagrams.
(and it can also create Java classes for these diagrams).

Check out the onlin demo here:
http://www.oracle.com/technology/products/jdev/viewlets/10g/DatabaseModeling_viewlet_swf.html

Download for free, yes. Use for free: only under certain circumstances...

 

[steve]

Download for free, yes. Use for free: only under certain circumstances...

oracle software is NOT "FREE", they place MOST oracle software on their
website, including the databases.

If you want to evaluate the software you can, but it is not to be used in
production.


Steve