Red Gate forums :: View topic - Feature requests
Return to www.red-gate.com RSS Feed Available

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

Feature requests

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



Joined: 20 Jan 2010
Posts: 5
Location: Jupiter, FL
PostPosted: Wed Jan 20, 2010 4:47 pm    Post subject: Feature requests Reply with quote
It would be nice if I could distinguish the types of dependancies when evaluating connected objects - for example, there are times when I'm only interested in evaluating queries that write to a particular table, and it would be helpful to ignore table read references (SELECT).

It would be great if DT could evaluate dependancies within SSIS packages - I've not seen a tool yet that could do that.

It would be nice in the graphing if I could see more of a workflow layout - if I could pick one object and define it as a central point, and have all related objects flow to/from it, or as a top level point and have all related objects cascade down from it... So, for example, if I have a particular table and I want to see how data flows in and out of it, I would set that as my central point... all queries that write to it appear on the left side, and all queries that read from it appear on the right side; queries that both read and write are clustered beneath. (...and, if I'm ignoring read references in queries, both write and read/write queries are diagrammed on the left side.)

Last edited by rreitz on Wed Jan 20, 2010 5:12 pm; edited 1 time in total
Back to top
View user's profile Send private message
rreitz



Joined: 20 Jan 2010
Posts: 5
Location: Jupiter, FL
PostPosted: Wed Jan 20, 2010 5:11 pm    Post subject: Reply with quote
My ulimate vision would be something like this...

I start with a query that writes to a table...
That table gets replicated to another server...
A view exists on the replicated table...
A job step selects data from the view into a different table...
An SSIS package exports the new table to a text file...

...and Dependancy Tracker is able to follow the original data point through all of these transitions, and diagram it as a data workflow.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
PostPosted: Thu Jan 21, 2010 8:47 pm    Post subject: Reply with quote
Thank you for your suggestions.

I have created a new Feature Request report. The Reference number is DT-577.

I cannot guarantee that the request will obtain approval and if approval is given, in what future version of SQL Dependency Tracker the requested features will appear in.

Thank you for taking the time to post your SQL Dependency Tracker suggestions.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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