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?
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.
An ERDM diagram is said to be closed (CERD) iff it has at least one loop in it.
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
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!!!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With