Various stored procedures that are used to import and export JSON Data
Switch branches/tags
Nothing to show
Clone or download
Phil Factor Phil Factor
Latest commit 1388d58 Dec 11, 2018
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitattributes
ArrayInArrayJsonDataFromTable.sql
BatchToSaveDataToDisk.sql
CreateJSONArrayInArraySchemaFromTable.sql
CreateJSONSchemaFromTable.sql
ExampleofCreateJSONSchemaFromTable.sql
JsonResultToJsonArray.sql
ReadMe.md
SaveAllTables as ArrayinArrayJSON.sql
SaveJSONDataToTable.sql
SaveJSONToFile.sql
SaveJsonDataFromTable.sql
SelectJSONIntoTable.sql
ValidateViaJSONSchema.ps1

ReadMe.md

SQL Server and JSON: Data import, export and validation

This repository contains several stored procedures and PowerShell routines that can be used for inserting JSON data into SQL Server, validate the data or to export the data from SQL Server. They are described in a series of articles on the Red-Gate site and in Simple-Talk. Some use ordinary json files and others show how to include the schema and data in one document.

CreateJSONSchemaFromTable.sql

This temporary procedure creates a JSON schema from a table that matches the JSON you will get from doing a classic FOR JSON select * statemenmt on the entire table

ExampleofCreateJSONSchemaFromTable.sql

This code is an example of the sort of routine that prepares a schema and JSON from the contents of a table

BatchToSaveDataToDisk.sql

This is an example of a batch that creates a number of temporary procedures before saving the contents of a database to disk as JSON files that have both the schema and the data in one file.

SaveJsonDataFromTable.sql

This gets the JSON data from a table, taking into account all the problems that can come about such as dealing with CLR data types

SaveJSONDataToTable.sql

This saves a JSON file to a table, dealing with the complications of having old deprecated data types and CLR data types

SaveJSONToFile.sql

This is a utility stored procedure for saving text to a file It is designed to save as utf-8 for JSON files but will do any file

SelectJSONIntoTable.sql

This is a way of taking a JSON string that contains both the schema and the data, and inserting it into a table in the database you wish

ValidateViaJSONSchema.ps1

Shows how to validate a directory, with a subdirectory with the schema and a parallel directory with the data