How to extract json from a relational db?

[Fred Wallace]

I don’t like writing a lot of procedural code, and so I’d like to know a common way to extract data from relational tables and move it into hierarchical json.

Right now, I am using MS SQL Server database, but I would like to perform this migration using My SQL database also.

I am using java and java connectivity database for access. I’d prefer any of these two databases to be able to assemble all the records on the server side.

[David Townsend]

Hi,

First of all, SQL Server itself doesn’t support json, so you’ll need to figure out your own way if you want to accomplish this.

To help you, I’ve found a good post illustrating a number of string manipulation techniques in TSQL:

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/