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

ben600

Nice informative tips about Redgate tool for the newbies

offshorededi

Jessica, You Saved Me, I was searching for something like this.

mikee500

thanks for sharing the updates as i was looking for them and it helps

defendersurf

Jessica, Your answer helped me. thankyou!

hawthoodlum

Very Helpful. thanku.

james410

nice to know the detailed guide here

Johnsontvc

Great post, a lot of stuff in here i did not know about 

Simona

Mind blowing post, I know a couple of things on SQL, but this is something new that I found, I will start following this blog

Chrisl007

One thing you can do to make dependency tracker less annoying and tedious is to open up your database (for me it is SSMS) and then right click on the specific object or objects and "View Dependency Diagram". From here you can resolve missing dependencies on an object-by-object basis.

It would be nice if selecting specific objects in Dependency Tracker actually worked but for now what i stated above is fairly painless.

rajpatel

good exercises for 12 (kids) year olds at home. workout for 12 year olds at home