从现有Oracle数据库生成数据库图/ER图的工具? [英] Tools to generate a database diagram/ER diagram from existing Oracle database?

问题描述

寻找工具(Windows平台)以从现有Oracle数据库生成ER图(或类似图表).
有没有可以免费使用或价格低廉的好工具?

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?

推荐答案

几年前，我使用了Data Architect，它是Sybase Power Designer的一部分.这有点贵，但是很棒.并在数据的物理(SQL)模型和ER数据模型之间做出了很好的区分.它将两个模型并排放置.

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.

如果您不太担心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.

使用新的空数据库启动MS Access.设置表链接以链接到架构中的所有表，或者仅链接到要绘制的表.使用Access中的关系"工具在外键和它们所引用的主键之间创建行.将这些关系分类为多对多或多对一.

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.

这篇关于从现有Oracle数据库生成数据库图/ER图的工具?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！