什么是适用于 Linux 的好的数据库 ERD 工具？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14032/
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
What's a Good Database ERD Tool for Linux?
提问by Rob Wilkerson
I've recently switched to Linux on my work machine and, new to the Linux desktop environment, I'd like to find a decent ERD tool for database design. Booting back into my Windows partition every time I need to create a diagram is going to get unpleasant quickly. I looked at Dia, but didn't see any DB tools - only UML, networking, etc.
我最近在我的工作机器上切换到 Linux，并且是 Linux 桌面环境的新手，我想为数据库设计找到一个像样的 ERD 工具。每次我需要创建图表时都重新启动到我的 Windows 分区会很快变得不愉快。我查看了 Dia，但没有看到任何数据库工具——只有 UML、网络等。
Anyone have any recommendations? For what it's worth, I'm using Ubuntu (Hardy Heron).
有人有什么建议吗？就其价值而言，我使用的是 Ubuntu（Hardy Heron）。
Thanks.
谢谢。
采纳答案by Rob Wilkerson
As a stop gap, I've installed DBDesigner via Wine (I should have just done that first) since that's what my Windows developers are using, but will look at both of these as well. The Eclipse plugin would be ideal if it's decent.
作为止损，我已经通过 Wine 安装了 DBDesigner（我应该先这样做），因为这是我的 Windows 开发人员正在使用的，但也会同时考虑这两个。Eclipse 插件如果合适的话将是理想的。
Thanks.
谢谢。
回答by SCdF
No recommendations as such, but,
没有这样的建议，但是，
You might want to broaden your search to Eclipse plugins such as http://eclipse-erd.sourceforge.net/.
您可能希望将搜索范围扩大到 Eclipse 插件，例如http://eclipse-erd.sourceforge.net/。
Apart from that there are various ERD tools you have to pay for like Data Architect.
除此之外，您还必须支付各种 ERD 工具，例如Data Architect。
回答by Steve M
Check out SQL Developer: [http://sqldeveloper.solyp.com/download/index.html]
查看 SQL Developer：[ http://sqldeveloper.solyp.com/download/index.html]
回答by Dave Marshall
I'd definitely recommend Gliffy.comfor simple ER diagrams; it's an online flash-based tool. I wrote a small reviewof it a week ago.
对于简单的 ER 图表，我绝对会推荐Gliffy.com；它是一个基于 Flash 的在线工具。一周前我写了一篇关于它的小评论。
回答by levhita
Mmm I think the Linux version of MySQL Workbench is out for download at: http://forums.mysql.com/read.php?3,56274,56274#msg-56274
嗯，我认为 MySQL Workbench 的 Linux 版本可以在以下位置下载： http://forums.mysql.com/read.php?3,56274,56274#msg-56274
You can see the pre-release announcement here: http://dev.mysql.com/workbench/?p=138
您可以在此处查看预发布公告： http://dev.mysql.com/workbench/?p=138
They are still in alpha, but judging from the windows version this is gonna be "THE" ERD tool.
它们仍处于 alpha 阶段，但从 Windows 版本来看，这将是“THE”ERD 工具。
PD: For the ubuntu part, you are in luck, they say that ubuntu is "our Linux distro of choice".
PD：对于 ubuntu 部分，你很幸运，他们说 ubuntu 是“我们选择的 Linux 发行版”。
回答by Sten Vesterli
Look at Oracle JDeveloper (freeware). It is pure Java, so it will run on any platform. It will work against any database that you can connect to via JDBC. It builds database diagrams (and lots of other diagrams - it happens to be a complete Java IDE).
查看 Oracle JDeveloper（免费软件）。它是纯Java，因此可以在任何平台上运行。它适用于您可以通过 JDBC 连接的任何数据库。它构建数据库图表（以及许多其他图表 - 它恰好是一个完整的 Java IDE）。
It works with a concept of "offline database objects" stored in XML files. So if you have existing database objects, you start by capturing them into JDeveloper and then build your diagram. If you make changes to your offline objects, you can "reconcile" them back into your database, either as new objects (DROP-REPLACE) or as modifications (ALTER).
它使用存储在 XML 文件中的“离线数据库对象”概念。因此，如果您有现有的数据库对象，则首先将它们捕获到 JDeveloper 中，然后构建您的图表。如果您对离线对象进行了更改，您可以将它们作为新对象 (DROP-REPLACE) 或修改 (ALTER) 重新“协调”到您的数据库中。
Download at http://www.oracle.com/technology/software/products/jdev/index.html
在http://www.oracle.com/technology/software/products/jdev/index.html下载
回答by levhita
MySQL just officially released the alpha of "MySQL Workbech for linux":
MySQL刚刚正式发布了“MySQL Workbech for linux”的alpha版本：
See the announcement here: MySQL Workbench 5.1 Alpha for Linux available.
请参阅此处的公告： 适用于 Linux 的 MySQL Workbench 5.1 Alpha 可用。
回答by Gianluca Della Vedova
For a generic (vendor independent) tool, you can try dia (I prefer the dia-gnome package). There are also some plugins for generating the SQL files.
对于通用（独立于供应商）工具，您可以尝试 dia（我更喜欢 dia-gnome 包）。还有一些用于生成 SQL 文件的插件。
回答by Gianluca Della Vedova
MySQL Workbench is available on MacOS, Fedora, Ubuntu, Windows.
MySQL Workbench 可在 MacOS、Fedora、Ubuntu、Windows 上使用。
WB 5.1 is focused on Data Modeling (replacing Mike Zinner's popular DBDesigner product).
WB 5.1 专注于数据建模（取代 Mike Zinner 流行的 DBDesigner 产品）。
WB 5.2 (coming April 2009) will include a ground up rewrite of the MySQL Query Browser.
WB 5.2（2009 年 4 月发布）将包括对 MySQL 查询浏览器的彻底重写。
回答by Leigh Pyle
I had bad experience with Workbench on Linux in the past and wish it got better now.
我过去在 Linux 上使用 Workbench 的经历很糟糕，希望它现在变得更好。
I am quite happy with SchemaBankthese days 'cause they are purely web-based. You drop them a few bucks every month and they host your diagram for private / public sharing. Usual stuff like forward / reverse engineering, alter scripts, etc are all supported.
这些天我对SchemaBank非常满意，因为它们完全基于网络。你每个月给他们几块钱，他们托管你的图表供私人/公共共享。像正向/逆向工程、修改脚本等常用的东西都得到支持。
