Add cross-database dependencies?

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Add cross-database dependencies?

Postby alicorn2 » Tue Apr 23, 2013 10:24 pm

I have approximately 50 databases, spread across 4 SQL Server instances.

I know I can find out which external objects things inside my current database rely on - but I want to do the reverse. I want to find out what all is pointing AT my current database, so that I know what will break when I try to move this database.

Is there a way to do this?

I tried adding all objects in each database, one database at a time. I eventually hung the application when I tried to get it to resolve external references, it encountered a reference to a database that doesn't exist anymore.
alicorn2
 
Posts: 3
Joined: Fri Apr 16, 2010 7:50 pm

Postby Anu Deshpande » Thu Apr 25, 2013 2:38 pm

Many thanks for your post.

I have logged a support call for you call reference for which is F0072188.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests