Looking for tools (windows platform) to genereate ER diagram (or similar) from an existing Oracle database.
Any good tools out there that are free to use or low cost?
views:
1595answers:
9
+4
A:
Try out Oracle SQL Developer. It is from oracle and is going to be part of actual oracle installation from 11g onwards.It has an in build modeler to engineer or re-engineer an ER model.
Other tool that may be useful that will help you more than just genereate ER diagram is SchemaSpy
+1 for SchemaSpy
mmrobins
2010-01-19 09:21:51
The SQL Developer Data Modeler is not built-in, it is a separate product. Also, it is not free, and at USD3000 per seat probably cannot in all conscience be called low cost.
APC
2010-01-19 10:46:56
+2
A:
I few years ago, I used Data Architect, part of Power Designer from Sybase. It's a little pricy, but it's excellent. And it makes a fine distinction between the physical (SQL) model of data and the ER model of data. It keeps both models side by side.
If you are not too concerned about the difference between SQL and ER, and you just want a diagram, here's something I did once when I needed a diagram in a big hurry.
Crank up MS Access with a new empty database. Set up table links to all the tables in the schema, or just the ones you want to diagram. Use the "Relationships" tool in Access to create lines between the foreign keys and the primary keys they refer to. Classify these relationships as to many-to-many or many-to-one.
In the Access relationships view, move the boxes around until the diagram is pretty. Print.
Walter Mitty
2010-01-19 12:28:49
+2
A:
You can use VISIO with an ODBC data source (oracle plugin) to generate ER diagrams - works well. From VISIO (Database Model Diagram, Reverse Engineer, select ODBC data source, username/password, select tables, generate).
Stellios
2010-01-20 06:54:19
+1
A:
We use Enterprise Architect from Sparx Systems. It's expensive but they do a trial version so you could try that.
Dave7896
2010-01-20 21:16:04
+1
A:
SchemaCrawler for Oracle is a command-line tool that can generate database diagrams from an Oracle database. You can exclude tables and columns from the diagram using regular expressions. It is free and open-source.
Sualeh Fatehi
2010-03-15 19:07:44