Newbie question: If I get the schemas of multiple related databases, is there anyway to diagrammatically generate a logical database diagram (linking keys, …)
The best way to create a diagram of multiple DBs and its external references would be to use SQL Dependency Tracker. You can achieve that by adding the additional DBs to your existing project.
As @Anderson said, SQL Dependency Tracker is the tool to get a dependency diagram; SQL Doc will only list the FK keys and what they link to- it does not have diagrams.
Answers
You can achieve that by adding the additional DBs to your existing project.
https://documentation.red-gate.com/sdt3/customizing-the-diagram/dealing-with-unresolved-internal-and-external-references
As @Anderson said, SQL Dependency Tracker is the tool to get a dependency diagram; SQL Doc will only list the FK keys and what they link to- it does not have diagrams.
Kind regards,
Alex
Have you visited our Help Center?