Tools to generate a database diagram/ER diagram fr

2019-01-16 14:46发布

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?

9条回答
Juvenile、少年°
2楼-- · 2019-01-16 15:28

Power Architect is a GPL data modelling tool. See more here

查看更多
手持菜刀,她持情操
3楼-- · 2019-01-16 15:29

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.

查看更多
女痞
4楼-- · 2019-01-16 15:34

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

查看更多
Ridiculous、
5楼-- · 2019-01-16 15:39

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

查看更多
叼着烟拽天下
6楼-- · 2019-01-16 15:41

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).

查看更多
孤傲高冷的网名
7楼-- · 2019-01-16 15:42

Oracle Data Modeler. It's free, and seems to have many good features if you're willing to research it more in depth.

查看更多
登录 后发表回答