blocks|key|1354785|text|试试Oracle+SQL+Developer吧。它来自oracle，从11g开始将成为oracle实际安装的一部分。它有一个separate+build+modeler+tool来设计或重新设计一个ER模型。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1354786|除了生成ER图之外，其他有用的工具还有SchemaSpy|1354787|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technology/products/database/sql_developer/index.html|1|http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html|2|http://schemaspy.sourceforge.net/^0|2|K|0|1Q|R|1|0|J|9|2|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]|$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|F|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]|P|$5|I|J|K|C|$L|Q]]]]

Try out <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="noreferrer">Oracle SQL Developer</a>. 
It is from oracle and is going to be part of actual oracle installation from 11g onwards. It has a <a href="http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html" rel="noreferrer">separate build modeler tool</a> 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 <a href="http://schemaspy.sourceforge.net/" rel="noreferrer">SchemaSpy</a>

blocks|key|1354836|text|几年前，我使用了数据架构师，它是Sybase的Power+Designer的一部分。它有点贵，但它很棒。它对数据的物理(SQL)模型和数据的ER模型进行了细微的区分。它使两个模型并排在一起。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1354837|如果您不太关心SQL和ER之间的区别，并且您只需要一个图表，那么当我非常着急地需要一个图表时，我曾经这样做过一次。|1354838|使用新的空数据库启动MS+Access。设置指向架构中所有表的表链接，或者只设置要绘制图表的表的链接。使用Access中的“关系”工具在外键和它们所引用的主键之间创建行。将这些关系分类为多对多或多对一。|1354839|在Access+relationships视图中，移动方框，直到图表美观为止。打印。|1354840|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

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.

blocks|key|1354890|text|Power+Architect是一种GPL数据建模工具。查看更多here|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1354891|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlpower.ca/page/architect^0|W|4|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Power Architect is a GPL data modelling tool.
See more <a href="http://www.sqlpower.ca/page/architect" rel="nofollow noreferrer">here</a>

blocks|key|1354951|text|您可以将VISIO与ODBC数据源(oracle插件)一起使用来生成ER图-效果很好。从VISIO+(数据库模型图、反向工程、选择ODBC数据源、用户名/密码、选择表、生成)中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1354952|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|1354993|text|我们使用Sparx+Systems的Enterprise+Architect。它很贵，但他们做了一个试用版，所以你可以试一下。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1354994|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

We use Enterprise Architect from Sparx Systems. It's expensive but they do a trial version so you could try that.

blocks|key|1355069|text|TOAD+professional现在包括了他们的数据建模工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1355070|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

TOAD professional now includes their data-modeling tool.

blocks|key|1140038|text|SchemaCrawler+for+Oracle是一个命令行工具，可以从Oracle数据库生成数据库图。可以使用正则表达式从图表中排除表和列。它是免费的，并且是开源的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1140039|entityMap|0|LINK|mutability|MUTABLE|url|http://schemacrawler.sourceforge.net/^0|0|O|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://schemacrawler.sourceforge.net/" rel="nofollow noreferrer">SchemaCrawler for Oracle</a> 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.

blocks|key|1355217|text|Oracle+Data+Modeler。它是免费的，如果你愿意更深入地研究它，它似乎有很多很好的功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1355218|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html^0|0|J|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html" rel="nofollow">Oracle Data Modeler</a>. It's free, and seems to have many good features if you're willing to research it more in depth.

blocks|key|1355274|text|SQL+Developer太棒了。支持所有的数据库，非常适合逆向工程。它是免费的和Java的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1355275|它与上面列出的其他解决方案不同，它是免费的，我只是用它对Postgres数据库进行了逆向工程！|1355276|entityMap|0|LINK|mutability|MUTABLE|url|http://sqldeveloper.solyp.com/^0|0|D|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

<a href="http://sqldeveloper.solyp.com/" rel="noreferrer">SQL Developer</a> 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!!!

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?

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

命令行工具

Oracle数据库

数据建模

数据架构

数据库

Java

寻找工具(视窗平台)，以生成ER图(或类似)从现有的Oracle数据库。有没有免费或低成本的好工具？

问从现有Oracle数据库生成数据库关系图/ER关系图的工具？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从现有Oracle数据库生成数据库关系图/ER关系图的工具？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从现有Oracle数据库生成数据库关系图/ER关系图的工具？
EN