适用于mysql的开源ER绘图工具 [英] Open source ER diagramming tool for mysql

问题描述

我想对我拥有的数据库的数据库定义转储进行逆向工程(导入图表形式)，然后由于在此特定数据库中未定义外键，因此我希望能够手动创建表到表的键映射(如果可能，请使用鱼尾纹符号).

I want to reverse engineer (import into diagram form) the database definition dump of a database I have, then since no foreign keys are defined in this particular database, I want to be able to manually create the table to table key mappings (using crow feet notation if possible).

我看过MySQL Workbench，它使我的工作效率提高了85％. 但是，不会显示漂亮的小关系线，并且自动排列太可怕了.快速搜索Google会发现其他几种选择，因此我可以自己评估这些选择，但是:

I've taken a look at MySQL Workbench, and it gets me 85% of the way there. The nice little relationship lines won't show up though, and the auto arrange is horrible. A quick search of google turns up several other options, so I can evaluate these on my own, but:

我可以从你们那里获得一些反馈吗?对于您来说，在这种情况下，您最喜欢使用哪些工具?您为什么喜欢那个(您的)特定工具?

Can I get some feedback from you guys for which are your favorite tools to use for this scenario? Why do you like that(your) particular tool?

我的预期目的是获取旧版数据库并培训jr.数据库组织的工程师.视觉辅助工具很漂亮.我的后备选项是手动重新创建ER图. 250个以上的桌子不好玩.

My intended purpose is to take a legacy database, and train jr. engineers on the organization of the DB. Visual aids are nifty. My fallback option is to recreate an ER diagram by hand. Not fun for 250+ tables.

推荐答案

您可能会签出DBDesigner ...

You might check out DBDesigner ...

现在称为MySQL Workbench

Now known as MySQL Workbench

http://dev.mysql.com/downloads/workbench/5.0.html

这篇关于适用于mysql的开源ER绘图工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！