是否有比MS SQL Server更强大的数据库图表程序？

I want program give me more helpful diagram for example:

我想程序给我更多有用的图例如:

MS SQL Server Diagram didn't give you a good design for relations so if you have many relations in the same table then the diagram just draw many lines to your table and didn't set the lines to specific column that would confuse you if you have many tables and complicated Database.

MS SQL Server Diagram没有给你一个很好的关系设计,所以如果你在同一个表中有很多关系,那么图表只是在你的表中画了很多行,并没有将这些行设置为特定的列,如果你混淆了你有很多表和复杂的数据库。

6 个解决方案

#1

You can drag the end points of the lines down to the individual keys. But if you move the table, they all move back up to the top of the table.

您可以将线条的端点向下拖动到各个键。但是如果你移动桌子,它们都会移回到桌面的顶部。

#2

Try MS Visio. I think that will fit your bill. A better alternate would be ERWIN.

试试MS Visio。我认为这符合你的账单。一个更好的替代品是ERWIN。

Raj

#3

Here are three good ones I have used (from most expensive to cheapest)

以下是我使用的三个好的(从最贵到最便宜)

Computer Associates - ErWin

Computer Associates - ErWin

Embarcadero - ER/Studio

Embarcadero - ER / Studio

ModelRight

However, I will say that your problem is more or less inevitable with complicated databases and is better dealt with via good naming conventions than with lines on the diagram. If your column names are consistent it goes a long way towards readability.

但是,我会说,对于复杂的数据库,您的问题或多或少是不可避免的,并且通过良好的命名约定比使用图中的行更好地处理。如果您的列名称一致,则可用性很长。

#4

I have used ER/Studio for years. It works great but is quite expensive.

我已经使用ER / Studio多年了。它工作得很好,但相当昂贵。

#5

Fabforce DBDesigner is a good one in the freeware section... optimized for MySQL.

Fabforce DBDesigner是免费软件部分中的一个优秀版本...针对MySQL进行了优化。

Version 4.0 used to be buggy, but had more features than Version 5.0 which is now MySQL/SUN owned.

版本4.0曾经是错误的,但有比版本5.0更多的功能,现在MySQL / SUN拥有。

Try both versions.

试试这两个版本。

#6

Also you can try Online Data Modeler , http://data-modeler.com . If you have complicated database, you could draw more diagrams of selected tables...

您也可以尝试使用Online Data Modeler,http://data-modeler.com。如果您有复杂的数据库,您可以绘制更多选定表格的图表...

#1