Auto generating logical architecture diagrams

chrsjns

Newbie question: If I get the schemas of multiple related databases, is there anyway to diagrammatically generate a logical database diagram (linking keys, …)

Anderson

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.

https://documentation.red-gate.com/sdt3/customizing-the-diagram/dealing-with-unresolved-internal-and-external-references

Alex B

Hi @chrsjns,

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