Are Cross-database dependencies available?

In the "Used By" section of a SQL object in SQL doc, I can see all objects references within the scope of a single database.  However, if that object (such as a view) is used by another database, the "Used By" section does not reflect this.  Is this the intended behavior?
Tagged:

Answers

  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    edited October 4, 2018 7:33AM
    Hi kakins-tamus

    Thank you for your forum post.

    SQL Doc does not show cross database dependencies.  Also it does not support Linked Servers and tables from other servers.  It will only show the objects within the single database you are generating the documentation for.

    I have added the details of this forum post to an existing enhancement request whose reference is SDOC-1044. I will update this post if this enhancement appears in a later version of SQL Doc.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • BobHarrisBobHarris Posts: 2 New member
    This is incorrect. My SQL Doc project contains 3 databases (on the same server) and the dependencies are definitely shown. It's a great feature and works perfectly. I only wish we could add cross server dependencies.
Sign In or Register to comment.