Add cross-database dependencies?
alicorn2
Posts: 5
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.
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.
Comments
I have logged a support call for you call reference for which is F0072188.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com