database 有哪些很棒的在线数据库建模工具?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/124467/
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 are some great online database modeling tools?
提问by
What's your favorite open source database design/modeling tool?
您最喜欢的开源数据库设计/建模工具是什么?
I'm looking for one that supports several databases, especially Firebird SQL but I can't find one on Google.
我正在寻找一种支持多种数据库的数据库,尤其是 Firebird SQL,但我在 Google 上找不到。
回答by itsmatt
I've used DBDesignerbefore. It is an open source tool. You might check that out. Not sure if it fits your needs.
我以前使用过DBDesigner。它是一个开源工具。你可能会检查一下。不确定它是否符合您的需求。
Best of luck!
祝你好运!
回答by Milan Babu?kov
Do you mean design as in 'graphic representation of tables' or just plain old 'engineering kind of design'. If it's the latter, use FlameRobin, version 0.9.0 has just been released.
您是指“表格的图形表示”中的设计还是简单的“工程类设计”。如果是后者,使用FlameRobin,0.9.0 版本刚刚发布。
If it's the former, then use DBDesigner. Yup, that uses Java.
如果是前者,则使用DBDesigner。是的,它使用 Java。
Or maybe you meant something more like MS Access. Then Kexishould be right for you.
或者,也许您的意思更像是 MS Access。那么Kexi应该适合你。
回答by tzot
S.Lott inserted a comment, but it should be an answer: see the same question.
S.Lott 插入了一条评论,但它应该是一个答案:see the same question。
EDIT
编辑
Since it wasn't as obvious as I intended it to be, here follows a verbatim copy of S.Lott's answer in the other question:
由于它不像我想要的那么明显,下面是 S.Lott 在另一个问题中的回答的逐字副本:
I'm a big fan of ARGO UMLfrom Tigris.org. Draws nice pictures using standard UML notation. It does some code generation, but mostly Java classes, which isn't SQL DDL, so that may not be close enough to what you want to do.
You can look at the Data Modelling Toolslist and see if anything there is better than Argo UML. Many of the items on this list are free or cheap.
Also, if you're using Eclipseor NetBeans, there are many design plug-ins, some of which may have the features you're looking for.
我是来自 Tigris.org的ARGO UML的忠实粉丝。使用标准 UML 符号绘制漂亮的图片。它会生成一些代码,但主要是 Java 类,而不是 SQL DDL,因此可能与您想要做的不够接近。
您可以查看数据建模工具列表,看看是否有比 Argo UML 更好的东西。此列表中的许多项目都是免费的或便宜的。
回答by Gudmundur Orn
The DB Designer Forkproject claims that it can generate FireBird sql scripts.
该DB设计师叉项目声称,它可以产生火鸟SQL脚本。
回答by ykaganovich
回答by Jeff Jones
You may want to look at IBExpert Personal Edition. While not open source, this is a very good tool for designing, building, and administering Firebird and InterBase databases.
您可能想查看IBExpert 个人版。虽然不是开源的,但它是一个非常好的设计、构建和管理 Firebird 和 InterBase 数据库的工具。
The Personal Edition is free, but some of the more advanced features are not available. Still, even without the slick extras, the free version is very powerful.
个人版是免费的,但一些更高级的功能不可用。尽管如此,即使没有华丽的附加功能,免费版本也非常强大。