I am trying to create a visual overview / diagram for an old SQL Server database. I have already looked through similar questions and articles, but I couldn't find a program that suits the task.
I have looked at SQL Server Management Studio, Datagrip and DBeaver, but none of them seem to visualize views and their dependencies. Please correct me if I am wrong.
Is there a program that can generate a diagram containing tables, views and their dependencies from SQL Server connections or backups?
•
I assume that you have ruled out the Database Diagrams feature that exists in SSMS? Can you elaborate why that wasn't suitable, as that'll give details on what features it is missing for your needs.
In addition to SSMS Database Diagrams feature, I've also used Redgate's SQL Dependency Tracker for visualisation as well, though that is a paid product.
When creating a new database diagram in SSMS I could only choose tables, not views. View dependencies can technically be viewed in the view design, but that will only show the dependencies for a single view, while I would like a diagram of the whole database.
