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?
Asked
Active
Viewed 9.3k times
19
-
Try using Dataedo http://dataedo.com - data dictionary and ERD generator for existing Oracle, SQL Server and MySQL databases. Enables documenting missing FKs, UKs, grouping into modules, pasting images and more. – Bad Pitt Sep 02 '16 at 15:55
-
There is a built-in [Oracle database designer](https://www.devart.com/dbforge/oracle/studio/oracle-database-diagram.html) in dbForge Studio. Check out a free 30-day trial for now. – Devart Aug 17 '18 at 12:06
9 Answers
23
Try out Oracle SQL Developer. It is from oracle and is going to be part of actual oracle installation from 11g onwards. It has a separate build modeler tool 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
APC
- 144,005
- 19
- 170
- 281
Santosh Gokak
- 3,393
- 3
- 22
- 24
-
4To use Oracle SQL Developer you need to connect to the database in question, export the DDL and then import the DDL with file -> data modeler -> import -> DDL File – Jazzepi Apr 23 '12 at 19:52
-
-
1@Jazzepi This is not correct. You open the `Data Modeler` tool, you go to `File` then to `Import` then to `Data Dictionary`and then from there you can connect to a database and have the tool generate the ERD for you. – p.matsinopoulos Jun 03 '16 at 10:23
-
-
What @Jazzepi said worked for me, since I already have a database created with data populated – Gabriel Hernandez Sep 01 '20 at 21:35
7
SQL Developer is awesome. Supports all the databases and perfect for reverse engineering. It free and Java.
Its Free unlike other solutions listed above and it works, I just used it to reverse engineer a Postgres db!!!
zengr
- 38,346
- 37
- 130
- 192
5
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
- 18,205
- 2
- 28
- 58
5
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
- 742
- 3
- 7
-
-
This feature is not longer present as of Visio 2013. (https://support.microsoft.com/en-us/kb/2259709) – Henrik Gering Dec 16 '15 at 14:28
4
Oracle Data Modeler. It's free, and seems to have many good features if you're willing to research it more in depth.
alextansc
- 4,626
- 6
- 29
- 45
1
We use Enterprise Architect from Sparx Systems. It's expensive but they do a trial version so you could try that.
Dave7896
- 829
- 5
- 11
1
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
- 4,700
- 2
- 24
- 28
-
How? I was going through spring,velocity example provided by you ..but didint got any API which can generate ER diagram..InputStream generateERDiagram(Java connection object)? – Rajesh Mar 08 '12 at 08:42