任何人都知道一个体面的免费DB模式逆向工程工具？ [英] Anyone know of a decent free DB schema reverse engineering tool?
问题描述
寻找能够从实时数据库自动创建MySQL数据库模式的图形表示的工具，显示表，列和关系（ER图）。理想情况下，在OS X上运行的程序会很好，但如果需要，我会使用其他机器运行它。
Looking for a tool that will automatically create a graphical representation of a MySQL DB schema from a live database, showing tables, columns, and relationships (an ER diagram). Ideally something that would run on OS X would be great but I'll take what I can get and run it on a different machine if necessary.
我检查了Google和del .icio.us。似乎大多数产品，这是商业。
I checked Google and del.icio.us. Seems most products that do this are commercial. I guess they're expensive to develop?
MySQL has the Workbench but it costs extra for the reverse engineering features.
这个开源工具 SchemaSpy 看起来有前途，但也许有点尴尬安装和使用。在我深入研究之前，我想我会检查是否有人知道更多的即时满足。
This open source tool SchemaSpy looks kind of promising, but maybe a little awkward to install and use. Before I dive into that, I thought I'd check whether anyone knows of something more "instant gratification."
推荐答案
SQuirreL 。
您需要右键单击并选择选项添加到图表。然后它将打开一个新的选项卡。切换到该选项卡后，您将看到在框中表示的表。只需右键单击该框，然后选择添加所有子级和添加所有父级。它将包括完整的层次结构，包括实体和关系。所以，你可以说它会产生一个ERD。
You need to right click the table and choose the option, 'Add to Graph'. Then it will open a new tab. After switching to that tab you will see the table represented in a box. Just right click the box and select 'Add all children', and 'Add all Parent'. It will include the complete hierarchy, with the Entity, and Relationships. So, you can say it would generate an ERD.
希望这会有所帮助。
这篇关于任何人都知道一个体面的免费DB模式逆向工程工具？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
