Linked Servers and External Dependencies (yes, again)

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Linked Servers and External Dependencies (yes, again)

Postby Long Haired Git » Mon Apr 19, 2010 2:06 am

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
Long Haired Git
 
Posts: 1
Joined: Mon Apr 19, 2010 1:40 am

Postby Linda Hawksworth » Wed Apr 21, 2010 1:12 pm

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.
Linda Hawksworth
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests