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

• 
  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!

  Jessica R February 07, 2019 17:19

  - 0 +
• 
  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
  

  Secant100 February 07, 2019 17:29

  - 0 +
• 
  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!

  Jessica R February 08, 2019 02:10

  - 0 +
• 
  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.

  mbruegel February 08, 2019 15:09

  - 0 +
• 
  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.
  

  Secant100 February 08, 2019 17:40

  - 0 +
• 
  thanks for the responses on this thread as i was looking for this query, really appreciate

  jones30 April 15, 2019 06:00

  - 0 +
• 
  Nice informative tips about Redgate tool for the newbies

  ben600 November 26, 2019 10:21

  - 0 +
• 
  Jessica, You Saved Me, I was searching for something like this.

  offshorededi December 23, 2019 14:25

  - 0 +
• 
  thanks for sharing the updates as i was looking for them and it helps

  mikee500 January 03, 2020 06:46

  - 0 +
• 
  Jessica, Your answer helped me. thankyou!
  

  defendersurf January 15, 2020 17:09

  - 0 +
• 
  Very Helpful. thanku.

  hawthoodlum February 16, 2020 04:14

  - 0 +
• 
  nice to know the detailed guide here

  james410 July 10, 2020 09:41

  - 0 +
• 
  Great post, a lot of stuff in here i did not know about 
  

  Johnsontvc August 31, 2020 12:47

  - 0 +
• 
  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
  

  Simona January 14, 2022 17:42

  - 0 +
• 
  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.

  Chrisl007 April 04, 2023 15:44

  - 0 +
• 
  good exercises for 12 (kids) year olds at home. workout for 12 year olds at home

  
  

  rajpatel July 10, 2023 02:40

  - 0 +

Add comment

Please sign in to leave a comment.