在ms-sql服务器上，获取所有对象之间的所有依赖项的最佳工具是什么？ [英] on ms-sql server, what is the best tool to get all the dependencies between all the objects?

问题描述

im寻找一个工具，获取有关对象之间的依赖关系的文档的信息，如表，视图，函数，触发器和过程。 ssms显示一些依赖关系，但是我无法将它们记录下来，因为微软说这个不全面。

im looking for a tool the get an info for documentation about the dependencies between the objects like tables, views, functions, triggers, procedures. the ssms shows some dependencies but i can't get them out for documentation and as microsoft says thei are not comprehensive.

我发现一个工具套件sqltoolbelt模块称为依赖关系跟踪器，有人知道它的体验吗？

I found a tool-suite "sqltoolbelt" with a module called Dependency Tracker, does anybody know it and how is the experience?

Peace

Ice

推荐答案

我会再次呼喊RedGate SQL依赖关系跟踪器。

I would second the shout for RedGate SQL Dependency Tracker.

只是一些有关此产品的更多信息，您可以通过特定的对象类型或名称可视地映射所有数据库或过滤器。所得到的图表有5种不同的样式，它们都可以输出到PDF，XML或图像文件。

Just some more information about this product, you can visually map all of your database or filter by specific object types or names. The resulting diagrams have 5 different styles and all of them can be output to PDF, XML or as an image file.

我个人认真建议您查看比较包SQL比较，SQL数据比较，依​​赖跟踪和SQL Packager。所有伟大的工具，而不是我不为RedGate工作，我刚刚发现他们的工具在过去3年无价之宝...

Personally I would seriously recommend you look at the Comparison Bundle of SQL Compare, SQL Data Compare, Dependency Tracker and SQL Packager. All great tools to have, and no I don't work for RedGate, I have just found their tools invaluable for the past 3 years...

这篇关于在ms-sql服务器上，获取所有对象之间的所有依赖项的最佳工具是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！