Documenting the database and the manual processes in between

Hi Recently started at a company where lots of the processes are manual interactions with the database. Lots of these things can be automated but before I do I would like to document the existing process and what procedure does what to which table preferably in a flowchart type thing. I know Visual studio comes to mind but does anybody know of software that can connect to the DB and you can pull objects in via drag and drop and add comments. So for example person ABC loads table1 which gets read by proc X and written to table2 and then updated by Person EFG The issue is that they have like a million procs and tables all having similar names which is why i ask for a drag and drop type feature as I need to document 1 process at a time.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Sep 02, 2016 at 12:23 PM

You can use Visio to reverse engineer the database into a data model. I don't believe that you can use it to map procedures though. You might also look at Red Gate's SQL Doc or Dependency Tracker. Both of those might help you down the right path.

1 ·