on ms-sql server, what is the best tool to get all the dependencies between all the objects? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 4 years ago.

开发者_高级运维 Improve this question

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.

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

Peace

Ice

---

I would second the shout for RedGate SQL Dependency Tracker.

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.

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...

---

Red Gate tools are highly recommended. I've use the Sql Toolbelt so it gets my thumbs up.

There is also SQL Search by Red Gate which is a new (free) tool - if you want to get a feel for what the Red Gate tools are like to use, either download that or the trial version of other tools. You'll soon get a feel for what their tools are like to use.