What Redgate tool creates a visual database diagram for an existing database

Secant100

How do I create a visual database diagram for an existing database

Jessica R

Hi @Secant100!

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!

Secant100

I tried sql-doc. It is more wordy and dba-stuff-like. I am using dependency tracker, but I have to go in and manually remove all the non-table stuff manually. Kindof a pain. My goal is to create a database table diagram that I can manually alter to show significant relationships, which unfortunately are NOT connected via foreign keys. I think the last time this was done, was 2014, using Visio. I don't mind doing that, but Red Gate should be able to do it better

Jessica R

Hi @Secant100,

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!

mbruegel

Some SQL IDE's have the ability produce a data model diagrams of limited utility.

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.

Secant100

I agree. I use Toad now and have also had ERWin in the past. ERWin is the big winner in that space, as far as I am concerned. I was hoping that Red Gate could do it better.

jones30

thanks for the responses on this thread as i was looking for this query, really appreciate