Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Tools to generate a database diagram/ER diagram from existing Oracle database? [closed]

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?

like image 391
Kb. Avatar asked Jan 19 '10 06:01

Kb.


People also ask

Which tool is used for creating ER diagram?

Lucidchart is the essential ERD tool to quickly differentiate relationships, entities, and their attributes. Include tables, fields, and primary or foreign keys, then connect each entity with specific crow's foot notations to indicate the cardinality and ordinality of each entity.

Can ER diagram be closed?

An ERDM diagram is said to be closed (CERD) iff it has at least one loop in it.


2 Answers

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

like image 124
Santosh Gokak Avatar answered Oct 13 '22 09:10

Santosh Gokak


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!!!

like image 28
zengr Avatar answered Oct 13 '22 09:10

zengr