Hi folks, 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
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.
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...