|
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. |
|||
|
|
|
I'd used Power Architect for this. It is Open Source/GPL |
|||
|
|
|
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. |
|||
|
|
|
There is a good article here on creating an Oracle schema diagramme in Visio. There is also the opensource alternative to Visio, Dia. |
|||
|
|
|
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. |
|||
|
|
|
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. |
|||
|
|
|
Oracle just started to offer one. Oracle SQL Developer Data Modeler: http://www.oracle.com/technology/products/database/datamodeler/index.html |
|||
|
