What Redgate tool creates a visual database diagram for an existing database
Secant100
Posts: 3 Bronze 1
How do I create a visual database diagram for an existing database
Tagged:
Answers
You can create a dependency diagram with SQL Dependency Tracker: https://www.red-gate.com/products/sql-development/sql-dependency-tracker/index
You might also be interested in SQL Doc which allows you to create documentation (as HTML, PDF, Microsoft Word or Markdown files) about databases: https://www.red-gate.com/products/sql-development/sql-doc/index
Hope that helps!
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Ah, I see and sorry that it's not easy to do with SQL Dependency Tracker at the moment!
I've created a feature request for more diagram editing/customization options with reference DT-735.
I also found a similar request on our uservoice forum. Could you please add a vote for it here: https://sqldependencytracker.uservoice.com/forums/164804-general/suggestions/15262689-schema-diagram
Thank you!
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?
For MS SQL I think SQL Server Management Studio has something built-in.
On the Oracle side SQLNavigator, Toad, or PL/SQL Developer have limited capabilities.
To really create and manage data models used as the starting point for development (or to reverse engineer a complex schema/database) turn to a full-feature data modeling tool like Idera's (Embarcadero) ER/Studio, or ERWin.
It would be nice if selecting specific objects in Dependency Tracker actually worked but for now what i stated above is fairly painless.