Monday, May 11, 2015

How do you obtain JSON formatted response to a SQL Query?

There are two ways you can do this as per my experience, but there could be more ways.
One method I found was to install the DocumentDB Migration tool from Microsoft and launch the program to convert the SQL Query response to a JSON format.

The details of the migration tool and downloading the tool are described here:

http://hodentek.blogspot.com/2015/05/tips-and-trick-to-format-sql-reponse-in.html

A step-by-step description of how it is done is described here:

http://hodentekmsss.blogspot.com/2015/05/migarting-from-sql-to-json-using.html

The second method is to download a software tool called SQL-JSON from the internet and use the tool. This tool can run both on Windows and Apple Mac OS. It can be used with SQL Server 2008 and SQL Server 2012 and requires Java Runtime 6 or 7.

The download link is here:
http://www.sqljson.com/index.html

No comments: