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.