Red Gate forums :: View topic - not possible to export list of dependencies
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

not possible to export list of dependencies

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



Joined: 05 May 2008
Posts: 59

PostPosted: Mon May 05, 2008 2:07 pm    Post subject: not possible to export list of dependencies Reply with quote

I am trying to determine all the objects used by a set of stored procs.
I can get a diagram showing the procs and all the objects used, but I cannot then either deselect the procs (just leaving the dependent objects) or even export only the dependent objects.

Is there a way to do this.
Back to top
View user's profile Send private message
austrianfoodispuke



Joined: 05 May 2008
Posts: 59

PostPosted: Mon May 05, 2008 3:14 pm    Post subject: Reply with quote

i did manage to hide the objects and only show the dependencies, but then to list out the unique objects i had to export this as xml, open in excel using the 'xml maps' function and then use an autofilter-copy unique to get the data out

not ideal
Back to top
View user's profile Send private message
chris.buckingham



Joined: 30 Jul 2007
Posts: 56

PostPosted: Thu May 08, 2008 2:22 pm    Post subject: Reply with quote

Thanks for your comments. I will pass them to the developers.
_________________
Chris Buckingham
Red-Gate support
Back to top
View user's profile Send private message Send e-mail
shadowbob



Joined: 02 Feb 2007
Posts: 52

PostPosted: Fri Jul 25, 2008 6:53 pm    Post subject: Reply with quote

I recently used Dependency Tracker for the first time, and my primary issue with it was similar to this thread. Let me describe my situation and what I was looking for; perhaps this will help focus the discussion.

When I need to do a dependency analysis, it involves not just the database but also other source code in various projects. This requires me to do multiple analyses in various manners and merge them into a central dependency tree. I create this tree as an Excel spreadsheet, which I then pass to my team to work on.

Dependency Tracker would be the ideal tool to perform the database portion of this analysis. The issue I ran into, however, is that there is no easy way to get the list of dependent objects out into Excel. Once I've brought up a diagram in Tracker, I just need the Type and Name of every dependent object. Preferably, I'd like to be able to just copy this list into the clipboard, and have it tab-delimited so it will paste into Excel as two columns. If not that, then I at least need a plain-text export. Again: I just need the list of dependent objects, not what their relationship is, or any other metadata beyond the type of object.

Tracker is not very useful to me until this kind of thing can be done easily. As it was, I had to manually retype the name of every object into my spreadsheet. Not the ideal situation.

The final piece to this would be creating an easy way to select just the objects that are dependents, and not select the original objects that I placed in the diagram for analysis. I already know what those objects are -- I don't need them any more.

Hope it helps! Thanks for another great tool.
Back to top
View user's profile Send private message
chuck aigen



Joined: 18 Apr 2008
Posts: 3

PostPosted: Fri Aug 08, 2008 4:46 pm    Post subject: printing/exporting list of dependencies Reply with quote

Does the new version (2.5) address the problem of exporting and/or printing the list of dependencies retrieved by the tracker software? This is an urgent need. I was told a few months ago that it might be included in sqlserver 2008 release.
thanks - chuck
Back to top
View user's profile Send private message
MarkWalker



Joined: 26 Mar 2009
Posts: 1
Location: Madison WI

PostPosted: Thu Mar 26, 2009 8:19 pm    Post subject: Reply with quote

I'm interested in this too. I have a very large database and I need to be able to export dependencies for only selected items.

Mark Walker
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