有哪些好工具可用于从 SQL Server 数据库生成 ERD？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/288620/
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 GOOD tools are available for generating ERD from a SQL Server Database?
提问by user6288
I am trying to generate an Entity Relationship Diagram from an existing MS SQLServer 2005 database. What tools are available? Specifically,I am not only interested in ERD's more directly I am looking for a tool to help quickly learning and analysing a medium size (schema wise not really row wise) database structure.
我正在尝试从现有的 MS SQLServer 2005 数据库生成实体关系图。有哪些工具可用？具体来说，我不仅对 ERD 更直接感兴趣，我正在寻找一种工具来帮助快速学习和分析中等规模（架构明智而非真正的行明智）数据库结构。
回答by Zahra
I can see that this post is quite old and MS SQL Server Management Studiomight have not had this feature back then! Though as far as I know with SQL Server 2012you can generate the ER diagrams by taking a few simple steps listed below:
我可以看到这篇文章已经很旧了，当时MS SQL Server Management Studio可能还没有这个功能！据我所知，在SQL Server 2012 中，您可以通过下面列出的几个简单步骤生成 ER 图：
- MS SQL Server management Studio > File menu > "Connect Object Explorer"
- Choose your Database node and expand it. under this node you'll find a sub-node called "Database Diagrams"
- Right click on "Database Diagrams" > "New Database Diagram" > Add tablesthat you wish to see their columns, relationships, ...
- MS SQL Server management Studio > 文件菜单 > “连接对象资源管理器”
- 选择您的数据库节点并展开它。在此节点下，您将找到一个名为“Database Diagrams”的子节点
- 右键单击“数据库图表”>“新建数据库图表”>添加您希望查看其列、关系、...
回答by lomaxx
The database reverse engineering feature of microsoft Visio are excellent for pulling the schema out of a database and developing from there. I'd investigate that avenue if you haven't already.
microsoft Visio 的数据库逆向工程功能非常适合从数据库中提取模式并从那里进行开发。如果你还没有，我会调查那条路。
回答by Nick DeVore
I've used Visio and had some good results with that. One thing I do though too is to use the visual designers (Database Diagrams) built into SQL Server GUI. When you drop the tables in there, it automatically includes the foreign keys. You can just include the tables you want at this point to focus in.
我使用过 Visio 并取得了一些不错的效果。我也做的一件事是使用内置于 SQL Server GUI 的可视化设计器（数据库图表）。当您将表放入其中时，它会自动包含外键。此时您可以只包含您想要关注的表。
All of these tools though anticipate the foreign keys pre-existing.
尽管所有这些工具都预计预先存在的外键。
回答by dkretz
I've been happy with DBDesigner4.
我对DBDesigner4很满意。
回答by dkretz
You can also generate an ERD from Microsoft Visual Studio 2005.
您还可以从 Microsoft Visual Studio 2005 生成 ERD。
