有没有一种工具可以实时显示我的 SQL 数据库图表？
我使用 Microsoft Office Visio 的“逆向工程”功能创建了一些 SQL 表的图表。我喜欢能够以这种方式可视化我的关系数据库。
然而，我得到的只是一个静态文档，我可以打印它，通过电子邮件发送给同事，然后单击小部件。
今年早些时候，我在一个演示中看到，新版本的 Visual Studio 2010 有一个名为“Architect Explorer”的新功能，它允许开发人员动态查看 .net 类之间的关系。它具有许多用于过滤开发人员感兴趣的数据的功能。
如果我可以直观地浏览我的表和存储过程，并查看与主键、外键以及存储过程中引用的内容相关的内容，那就太棒了。我意识到我正在谈论两种完全不同的技术，这不是一个完美的类比，但是是否有一些类似的工具可以让我可视化 SQL 数据库中的表？
I've created some diagrams of SQL tables using the "Reverse Engineer" feature of Microsoft Office Visio. I like being able to visualize my relational databases in this manner.
However, what I get is just a static document that I can print, e-mail to colleagues, and click widgets on.
Earlier this year, I saw at a demo that the new version of Visual Studio 2010 has a new feature called the "Architect Explorer", which allows developers to view relationships among .net classes on the fly. It has many features for filtering the data that the developer is interested in.
It would be really awesome if I could visually browse my tables and stored procedures and see what is related to what by primary key, foreign key, and referenced in stored procedures. I realize that I'm talking about two entirely different technologies and it's not a perfect analogy, but is there some similar tool that would allow me to visualize tables in my SQL database?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我见过 RedGate SQL Dependency Tracker 这样做：
I have seen RedGate SQL Dependency Tracker do this:
如果您已经在使用 Visio，则在从现有数据库进行逆向工程后，您应该能够刷新数据库图表。
查看：
关于将数据库模型图与数据库同步
这就是你要找的吗？
If you're already using Visio, you should be able to refresh your database diagrams after they've been reverse engineered from an existing database.
Check out:
About synchronizing database model diagrams with databases
Is that what you're looking for??