Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to diagram an oracle database and I am hoping to find some good tools that are either cheap, or free.

Ideally the tool should allow me to draw the relationships between the tables, as well as remove unwanted tables from the diagram.

I already have access to MS Visual Studio 2008 as well as SSMS 2008, but I don't believe either will provide much help with oracle.

share|improve this question
add comment

6 Answers

up vote 2 down vote accepted

I'd used Power Architect for this. It is Open Source/GPL

share|improve this answer
add comment

the perl sqlt program from the SQLFairy project (aka SQL::Translator) can read a database schema from a text file (or by directly querying the database using perl DBI) and translate the schema into a variety of formats, including some graphical/documentation formats such as Diagram and GraphViz and HTML.

it supports several different database backends, including Mysql, Postgresql, Sybase, and Oracle.

share|improve this answer
add comment

There is a good article here on creating an Oracle schema diagramme in Visio.

There is also the opensource alternative to Visio, Dia.

share|improve this answer
add comment

From Wikipedia:

Some free software ER diagramming tools that can interpret and generate ER models, SQL and do database analysis are StarUML, MySQL Workbench, and SchemaSpy. Some free software diagram tools just draw the shapes without having any knowledge of what they mean, nor do they generate SQL. These include Kivio and Dia. DIA diagrams, however, can be translated with tedia2sql.

share|improve this answer
add comment

If you have access to MS Access, you can create an ODBC connection to the DB and then link all your tables and use the relationship builder inside Access to build the diagram. This is typically what I do, as while it is not the best method, it sure is the easiest.

share|improve this answer
add comment

Oracle just started to offer one.

Oracle SQL Developer Data Modeler:

http://www.oracle.com/technology/products/database/datamodeler/index.html

share|improve this answer
    
I like the native option much better. I see they JUST release it about a month ago. Very nice. –  Russ Aug 11 '09 at 13:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.