从现有 Oracle 数据库生成数据库图/ER 图的工具？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2091599/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Tools to generate a database diagram/ER diagram from existing Oracle database?
提问by Kb.
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?
寻找工具（windows 平台）从现有的 Oracle 数据库生成 ER 图（或类似的）。
有没有免费或低成本的好工具？
采纳答案by Walter Mitty
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.
几年前，我使用了 Data Architect，它是 Sybase Power Designer 的一部分。它有点贵，但它很棒。它对数据的物理 (SQL) 模型和数据的 ER 模型进行了很好的区分。它将两个模型并排放置。
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.
如果你不太关心 SQL 和 ER 之间的区别，而你只是想要一个图表，这里是我曾经在急需图表时做过的事情。
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.
使用新的空数据库启动 MS Access。设置表链接到模式中的所有表，或者只是你想要绘制的表。使用 Access 中的“关系”工具在外键和它们引用的主键之间创建线。将这些关系分类为多对多或多对一。
In the Access relationships view, move the boxes around until the diagram is pretty. Print.
在访问关系视图中，四处移动框直到图表变得漂亮。打印。
回答by Santosh Gokak
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 toolto engineer or re-engineer an ER model.
试用Oracle SQL Developer。它来自 oracle，从 11g 开始将成为实际 oracle 安装的一部分。它有一个单独的构建建模工具来设计或重新设计 ER 模型。
Other tool that may be useful that will help you more than just genereate ER diagram is SchemaSpy
其他可能有用的工具不仅可以帮助您生成 ER 图，还可以使用SchemaSpy
回答by zengr
SQL Developeris awesome. Supports all the databases and perfect for reverse engineering. It free and Java.
SQL Developer很棒。支持所有数据库，非常适合逆向工程。它免费和Java。
Its Free unlike other solutions listed above and it works, I just used it to reverse engineer a Postgres db!!!
与上面列出的其他解决方案不同，它是免费的，并且有效，我只是用它来对 Postgres 数据库进行逆向工程！！！
回答by Stellios
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).
您可以将 VISIO 与 ODBC 数据源（oracle 插件）一起使用来生成 ER 图 - 效果很好。从 VISIO（数据库模型图，逆向工程师，选择 ODBC 数据源，用户名/密码，选择表，生成）。
回答by alextansc
Oracle Data Modeler. It's free, and seems to have many good features if you're willing to research it more in depth.
Oracle 数据建模器。它是免费的，如果您愿意对其进行更深入的研究，它似乎具有许多不错的功能。
回答by David
TOAD professional now includes their data-modeling tool.
TOAD Professional 现在包括他们的数据建模工具。
回答by Gary Myers
回答by Dave7896
We use Enterprise Architect from Sparx Systems. It's expensive but they do a trial version so you could try that.
我们使用 Sparx Systems 的 Enterprise Architect。它很贵，但他们提供试用版，因此您可以尝试一下。
回答by Sualeh Fatehi
SchemaCrawler for Oracleis 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.
SchemaCrawler for Oracle是一个命令行工具，可以从 Oracle 数据库生成数据库图表。您可以使用正则表达式从图表中排除表和列。它是免费和开源的。
