Our customers are in Oracle and SQL Server 2012. I was asked to create a script to transform data from the tables (which have parent-child relation) to JSON format. I'm bit new to JSON formatting. I was able to transform the data to JSON format in Oracle. But in SQL it's been bit challenging. Could you please suggest any Microsoft tools that would format the data to JSON and load the formatted data back in SQL Server (to a different table).