Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

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

Open more actions menu

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

Morty Proxy This is a proxified and sanitized view of the page, visit original site.