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.
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.
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.
It would be nice if selecting specific objects in Dependency Tracker actually worked but for now what i stated above is fairly painless.