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.
谢谢。
12 个解决方案
#1
12
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.
请参阅此处的公告：MySQL Workbench 5.1 Alpha for Linux可用。
#2
5
I'd definitely recommend Gliffy.com for simple ER diagrams, it's an online flash based tool, so cross platform. I wrote a small review of it a week ago.
我肯定会推荐Gliffy.com用于简单的ER图表，它是一个基于在线flash的工具，所以跨平台。我在一周前写了一篇小评论。
#3
3
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查询浏览器的重新编写。
http://forums.mysql.com/index.php?151
http://forums.mysql.com/index.php?151
#4
2
Check out SQL Developer: [http://sqldeveloper.solyp.com/download/index.html]
查看SQL Developer：[http://sqldeveloper.solyp.com/download/index.html]
#5
2
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-5674
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发行版”。
#6
2
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下载
#7
2
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文件的插件。
#8
1
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。
#9
1
I had bad experience with Workbench on Linux in the past and wish it got better now.
我过去在Linux上使用Workbench的经验很糟糕，并希望它现在变得更好。
I am quite happy with SchemaBank these 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非常满意，因为它们纯粹是基于网络的。你每月给他们掏几块钱，他们主持你的图表，用于私人/公共分享。所有支持前进/逆向工程，更改脚本等常用内容。
#10
0
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.
谢谢。
#11
0
You can try ORM Designer http://www.orm-designer.com Tool is similar to DBDesigner, but has much more functions and is under everyday development.
您可以尝试ORM Designer http://www.orm-designer.com工具类似于DBDesigner，但具有更多功能，并且在日常开发中。
#12
-3
You can try Base from LibreOffice. It can connect to any database and you can easily create, design and write queries using visual wizards and tools.
你可以尝试从LibreOffice Base。它可以连接到任何数据库，您可以使用可视向导和工具轻松创建，设计和编写查询。
#1
12
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.
请参阅此处的公告：MySQL Workbench 5.1 Alpha for Linux可用。
#2
5
I'd definitely recommend Gliffy.com for simple ER diagrams, it's an online flash based tool, so cross platform. I wrote a small review of it a week ago.
我肯定会推荐Gliffy.com用于简单的ER图表，它是一个基于在线flash的工具，所以跨平台。我在一周前写了一篇小评论。
#3
3
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查询浏览器的重新编写。
http://forums.mysql.com/index.php?151
http://forums.mysql.com/index.php?151
#4
2
Check out SQL Developer: [http://sqldeveloper.solyp.com/download/index.html]
查看SQL Developer：[http://sqldeveloper.solyp.com/download/index.html]
#5
2
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-5674
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发行版”。
#6
2
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下载
#7
2
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文件的插件。
#8
1
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。
#9
1
I had bad experience with Workbench on Linux in the past and wish it got better now.
我过去在Linux上使用Workbench的经验很糟糕，并希望它现在变得更好。
I am quite happy with SchemaBank these 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非常满意，因为它们纯粹是基于网络的。你每月给他们掏几块钱，他们主持你的图表，用于私人/公共分享。所有支持前进/逆向工程，更改脚本等常用内容。
#10
0
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.
谢谢。
#11
0
You can try ORM Designer http://www.orm-designer.com Tool is similar to DBDesigner, but has much more functions and is under everyday development.
您可以尝试ORM Designer http://www.orm-designer.com工具类似于DBDesigner，但具有更多功能，并且在日常开发中。
#12
-3
You can try Base from LibreOffice. It can connect to any database and you can easily create, design and write queries using visual wizards and tools.
你可以尝试从LibreOffice Base。它可以连接到任何数据库，您可以使用可视向导和工具轻松创建，设计和编写查询。