Skip to content

A program that parse out any column in SQL Server 2017 including the new JSON Columns

Notifications You must be signed in to change notification settings

dmerson/JSONCSVParser

Repository files navigation

JSONCSVParser

A program that parsez out any column in SQL Server 2017 including the new JSON Columns.

Configurable

You can configure the following parameters in the app.config:

  1. Connection String (Intended server)
  2. SQL Statement
  3. Final File Path- Where to place the final file
  4. Command Timeout -In case the sql statement takes a while to run

Future Development

Allow the deliminator to be changed via the app.config.

Current abilities tested

This version has been tested with exporting a table from SQL with 43K records and 60 columns for 110MB file size within 30 seconds. It correctly parse valid JSON fields.

About

A program that parse out any column in SQL Server 2017 including the new JSON Columns

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages