best tool for documenting your databases (more design decisions etc)

  • Any suggestions for a good tool for documenting a database and all the important objects in it? I'm trying to use Azure Data Tools, but not a huge fan. Maybe that's my best option, though?

  • This was removed by the editor as SPAM

  • Oh riiiiiiight! (silly me!) ... RedGate has such a tool. (It's a good thing that nobody that works for Red Gate is on here... you know, like Grant or Steve!)

    A lot of times, I feel like I should at least use a proper template for object creation and modification.... at least then you're sort of reminded to fill in the blanks and leave your future self some notes about what the spaghetti below is about.

  • Another good option is ApexSQL Doc. It generates detailed documentation, including dependencies and object relationships, which can be useful if you're tracking design decisions. If you prefer something lightweight, dbdocs.io can generate clean documentation from your schema.

  • If RedGate and ApexSQL Doc don’t fully meet your needs, another solid option is Dataedo, it’s great for capturing design decisions, relationships, and even business logic explanations.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply