We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.
Closed 9 years ago.
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(5)
如果您谈论的是 MS SQL Server 表,我喜欢 SQL Server Management Studio 中的图表支持。 您只需将表格从资源管理器拖到画布上,它们就会与关系线一起为您布置。 您必须手动进行一些调整才能获得最好看的图表,但这是获取图表的不错方法。
If you are talking about MS SQL Server tables, I like the diagram support in SQL Server Management Studio. You just drag the tables from the explorer onto the canvas, and they are laid out for you along with lines for relationships. You'll have to do some adjusting by hand for the best looking diagrams, but it is a decent way to get diagrams.
我更新了 Mark 关于 Toad Data Modeler 的帖子,并想指出他们有一个功能齐全且免费的测试版。 唯一的缺点是偶尔出现错误和内置过期(通常在新测试版可用时),但对于这个可怜的家伙来说,它确实创造了奇迹,直到我能让我的老板出钱获得许可证。
I upmodded Mark's post about Toad Data Modeler and wanted to point out that they have a beta version that is fully functional and free. The only downsides are the occasional bug and built in expiration (typically around the time a new beta is available), but for this poor bloke it does wonders until I can get my boss to chip in for a license.
我是 Embarcadero 的 ER/Studio 的忠实粉丝。 它功能非常强大,可以产生出色的屏幕和打印效果。 他们也有免费试用,所以你应该能够在没有太多冲突的情况下尝试一下。
祝你好运!
I am a big fan of Embarcadero's ER/Studio. It is very powerful and produces excellent on-screen as well as printed results. They have a free trial as well, so you should be able to get in and give it a shot without too much strife.
Good luck!
Quest 的 Toad Data Modeller 在这方面做得很好,而且价格合理。 正如 Bruce 提到的,Embarcadero E/R studio 也不错。
Toad Data Modeller from Quest does a nice job on this and is reasonably priced. Embarcadero E/R studio is good too, as Bruce mentioned.
OP询问图表视图和视图依赖关系,SQL Management Studio和企业管理器不允许您图表视图。 我不能保证其他工具。
Visual Studio 的 LINQ to SQL 设计器确实允许您将视图拖放到设计图面上,但没有一种简单的方法可以对视图之间的依赖关系进行建模。 我不确定哪个工具具有这种类型的图表功能。 您可以查看 Red Gate 的 SQLDoc 工具,但它只提供基于文本的输出。
OP asked about diagramming views and view dependencies, SQL Management Studio and Enterprise Manager doesn't allow you to diagram views. I can't vouch for the other tools.
The LINQ to SQL designer for Visual Studio does allow you to drop views on the design surface but there isn't a easy way to model the dependencies between the views. I'm not sure which tool has this type of diagramming functionality. You could take a look at Red Gate's SQLDoc tool but it just provides text based output.