Reading and Writing your Database’s Documentation using JSON

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I’m doing for Redgate’s Product Learning, I’ve been demonstrating how to maintain a single source of database documentation, in JSON, and then add and update the object descriptions during Flyway migrations. It is a single re-executable script that documents the tables, views and table-valued functions of a database, and their columns, from a central JSON document. This can be generated from the database using a separate script that produces a JSON representative