Red Gate forums :: View topic - Linked Servers and External Dependencies (yes, again)
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

Linked Servers and External Dependencies (yes, again)

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



Joined: 19 Apr 2010
Posts: 1

PostPosted: Mon Apr 19, 2010 2:06 am    Post subject: Linked Servers and External Dependencies (yes, again) Reply with quote

I have a legacy system with 6000+ artefacts across 20 databases I have to remediate. I am trialling this tool to determine if it can help me find unused debris, and moving forward, to assist the developers in understanding the impacts of making a change.

The issue is that our platform was built across five servers, but is now hosted on one server running two instances (Moore's Law ROCKS). I have read the tip about adding linked servers as aliases in SQL Network Utility (or equiv).

However, this appears to be creating multiple instances of a schema object that actually only exists once. The reason for this is that our lazy ill-disciplined programmers here happily used links created for one purpose to get to unrelated databases if that link got them to the right box.

So, as a feature request, what I want to do is to "declare" that an external reference "instance" is actually an instance already added to my project. Defining this thus would enable the dependency tracker to understand that Link_A.database_A.dbo.Table_A is the same thing as Link_B.database_A.dbo.Table_A which is the same thing as Server_Z\instance_Q.database_A.dbo.Table_A which I have already added to the project.
_________________
----
Long Haired Git
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Wed Apr 21, 2010 1:12 pm    Post subject: Reply with quote

Thanks for your suggestion. I have logged it as a feature enhancement in our tracking system with reference DT-586. It will be considered for a future release of SQL Dependency Tracker although we have no timescales for this at present.
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