Well, it doesn't do custom colors, but MySQL Workbench is a free database modelling tool provided by MySQL.
You can even set it up to reverse engineer a full schema diagram just by having it connect to your database. You could take it from there and partition out what you needed into separate modelling diagrams.
For any kind of graph drawing I really find it hard to beat the utility of Graphviz; but it'd require you to learn a new (and I use "learn" loosely here) language called "dot". The language is incredibly simple, and there's plenty of templates around for using it to document schemas.
On a side note, there's an excellent schema mapping tool which can infer connections based on column names that may get you pretty close to what you need, it's called SchemaSpy.
I use Visio. It has a reverse engineer capability that allows you to point to an ODBC source and it will pull in the tables, views and store procedures as drawing elements. If the contraints are present, it will auto connet the tables via their relationship. want to draw a sub-schema, just select the tables you need during the extraction and viola! it also has multiple pages inside the drawing so you can have a master page with everything and subsequent pages with subschema details embedded.
You can also set line styles, fill styles and font styles too. And If you are on MSDN, you already have it...
发布评论
评论（7）
嗯，它不支持自定义颜色，但是 MySQL Workbench 是 MySQL 提供的免费数据库建模工具。
您甚至可以将其设置为通过将其连接到数据库来对完整模式图进行逆向工程。您可以从那里获取它并将您需要的内容划分为单独的建模图。
Well, it doesn't do custom colors, but MySQL Workbench is a free database modelling tool provided by MySQL.
You can even set it up to reverse engineer a full schema diagram just by having it connect to your database. You could take it from there and partition out what you needed into separate modelling diagrams.
对于任何类型的图形绘制，我真的发现很难击败 Graphviz 的实用性；但这需要你学习一种新的（我在这里宽松地使用“学习”）语言，称为“点”。该语言非常简单，并且有大量模板可用于使用它来记录模式。
顺便说一句，有一个出色的模式映射工具，它可以根据列名称推断连接，这可能会让您非常接近您需要的内容，它被称为 SchemaSpy。
For any kind of graph drawing I really find it hard to beat the utility of Graphviz; but it'd require you to learn a new (and I use "learn" loosely here) language called "dot". The language is incredibly simple, and there's plenty of templates around for using it to document schemas.
On a side note, there's an excellent schema mapping tool which can infer connections based on column names that may get you pretty close to what you need, it's called SchemaSpy.
我喜欢 WWW SQL Designer 的简单性 (演示):
I enjoy the simplicity of WWW SQL Designer (Demo):
我用维西奥。它具有逆向工程功能，允许您指向 ODBC 源，并将表、视图和存储过程作为绘图元素提取。如果存在约束，它将通过表的关系自动连接表。想要绘制子模式，只需在提取和中提琴过程中选择您需要的表即可！它在绘图内还有多个页面，因此您可以拥有包含所有内容的母版页和嵌入子架构详细信息的后续页面。
您还可以设置线条样式、填充样式和字体样式。如果您在 MSDN 上，那么您已经拥有它......
I use Visio. It has a reverse engineer capability that allows you to point to an ODBC source and it will pull in the tables, views and store procedures as drawing elements. If the contraints are present, it will auto connet the tables via their relationship. want to draw a sub-schema, just select the tables you need during the extraction and viola! it also has multiple pages inside the drawing so you can have a master page with everything and subsequent pages with subschema details embedded.
You can also set line styles, fill styles and font styles too. And If you are on MSDN, you already have it...
尝试使用 SQLyog 架构设计器。使用起来非常简单直观。值得一试...
Try using SQLyog's Schema Designer. It is very simple and intuitive to use. Worth giving a try...
查看此处的开源图表工具。
这是另一个名为 DBDesigner 的东西，可以在此处找到。
希望这有帮助。
Check out this Open source Diagramming tool found here.
Here is another called DBDesigner found here.
Hope this helps.
1这是一个非常好的在线工具，你可以使用这个http://creately.com/diagram-type/database-design 。我正在使用这个。它还提供了功能为数据库表着色。
1It is a very nice online tools you can use this http://creately.com/diagram-type/database-design .I am using this .It also gives the functionality to color database tables.