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
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.
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.
Open SQL Server Management Studio (SSMS).In the Object Explorer on the left, expand your database.Right-click on Database Diagrams, and then select New Database Diagram.Donkey kong
Secant100
Posts: 3 Bronze 1
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.