Documenting the database and the manual processes in between


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.

more ▼

asked Sep 02, 2016 at 10:35 AM in Default

avatar image

21 3

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.

Sep 02, 2016 at 12:23 PM JohnM
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 02, 2016 at 10:35 AM

Seen: 99 times

Last Updated: Sep 02, 2016 at 12:23 PM

Copyright 2018 Redgate Software. Privacy Policy