Is there a way to only show dependencies at the database level for external dependencies?
Is there a way to only show dependencies at the database level for external dependencies? Management wants to see an ERD that shows all the database dependencies of a database but only at the database level including external databases. They do not need or want to see the table level info. Example - Database A has dependencies to multiple external databases on other SQL servers, database A has dependencies to Server B.B and server C.C and server D.D but database B also has dependency on server F.F and server G.G where database A does not have a direct direct dependency with either F or G. I know I could most likely get this done my hiding all the tables and then moving everything around to make it look pretty but don't really have the time to do that. Any ideas?
0 · Share on Twitter