Red Gate forums :: View topic - Feature Request : Add dependent objects to diagram
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Feature Request : Add dependent objects to diagram

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
johndempsey



Joined: 16 Dec 2010
Posts: 3

PostPosted: Wed Jan 19, 2011 5:25 am    Post subject: Feature Request : Add dependent objects to diagram Reply with quote

Hi,

Apologies if this is already here somewhere.

I think Dep. Tracker is great but I always find myself wanting to traverse areas of our large database (3000+ sps) without necessarily knowing the objects I need to add to the diagram to be able to do this.

I always find myself right-clicking on objects in my diagram and expecting to be able to "Add all dependent objects" to it.

As an example of what I mean, I would love to be able to add 1 proc (the entry point to a subsystem for example) to a diagram and right click to expand all objects directly related to it, and keep on doing this until I got the desired result/ information.

It may even be nice to be able to break it up and say...

Add all dependent objects
Add dependent procs
Add dependent tables
etc.

I hope I've explained myself!

Keep up the good work,

Cheers,

John Dempsey
Back to top
View user's profile Send private message
whenriksen



Joined: 18 Feb 2010
Posts: 16

PostPosted: Wed Jan 26, 2011 11:17 pm    Post subject: Reply with quote

I agree with JohnDempsey, I'd like the option to Show hidden depenendent objects, as well as dependencies.

However, a work around for now is to remove all objects except your entry point. From there you can add parent and child objects to diagram (Right-click -> Add to Project...).

Its not ideal, especially with a large diagram (mine is over 3k objects), but you can slowly step through your subsystem.

Also, Show/Hide still allows you to search for hidden objects and the diagram does not have to redraw when you show stuff. Adding objects requires the diagram to redraw, which can still take some time even with the very fast diagram types.
Back to top
View user's profile Send private message
johndempsey



Joined: 16 Dec 2010
Posts: 3

PostPosted: Mon Jul 25, 2011 12:17 am    Post subject: Reply with quote

For anyone reading this thread now, I figured out a workaround that I thought would be useful to share as it isn't entirely obvious.

1) Deselect all objects so that there are no objects on your diagram.
2) Select the entry point, whether that be a table, proc or something else.
3) In the dependencies panel, click the top dependency and then shift click the bottom one. This selects them all.
4) Double click the items you have just selected in the dependency panel. (This selects them in the upper object panel)
5) Check one of the selected items in the Objects panel.

This will add all dependent objects to your diagram at once.

Hope that helps somebody!

Cheers,

John.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group