# Importing JSON file using NEST

**URL:** <https://discuss.elastic.co/t/importing-json-file-using-nest/57790>\
**Category:** Elasticsearch\
**Created:** [August 11, 2016, 10:05am UTC](https://discuss.elastic.co/t/importing-json-file-using-nest/57790 "2016-08-11T10:05:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kiran306](https://avatars.discourse-cdn.com/v4/letter/k/ecc23a/32.png) [@kiran306](https://discuss.elastic.co/u/kiran306)\
**Post date:** [August 11, 2016, 10:05am UTC](https://discuss.elastic.co/t/importing-json-file-using-nest/57790/1 "2016-08-11T10:05:43Z")

</div>

I have current SQL DB currently running, I am trying move few of my tables to Elastic indexes.  
which is the easiest way.

i have gone through few link, nothing is pointing to what i am looking for.

[https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-bulk.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-bulk.html)  
[https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-index\_.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-index_.html)

> **[GA Release of NEST 2.0, our .NET client for Elasticsearch
	  	 | Elastic](https://www.elastic.co/blog/ga-release-of-nest-2-0-our-dot-net-client-for-elasticsearch)**
>
> This marks the first GA release of our 2.0 client with well over a 1000 commits since 1.7.1 (the currently last released NEST version in the 1.x range). Back to the drawing boardWe took some time to g...

  

> **[GA Release of NEST 2.0, our .NET client for Elasticsearch
	  	 | Elastic](https://www.elastic.co/blog/ga-release-of-nest-2-0-our-dot-net-client-for-elasticsearch)**
>
> This marks the first GA release of our 2.0 client with well over a 1000 commits since 1.7.1 (the currently last released NEST version in the 1.x range). Back to the drawing boardWe took some time to g...

  
[https://www.elastic.co/guide/en/elasticsearch/client/net-api/1.x/create-indices.html](https://www.elastic.co/guide/en/elasticsearch/client/net-api/1.x/create-indices.html)

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![forloop](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/forloop/32/9021_2.png) [@forloop](https://discuss.elastic.co/u/forloop)\
**Post date:** [August 12, 2016, 4:20am UTC](https://discuss.elastic.co/t/importing-json-file-using-nest/57790/2 "2016-08-12T04:20:02Z")

</div>

Using Logstash for this is one option, [with the jdbc plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html).

Another option would be to use one of the clients (such as NEST) in an application to read from the SQL database (maybe [using something like Dapper](https://github.com/StackExchange/dapper-dot-net) to hydrate records into POCOs), and then use NEST to send bulk requests of batches of documents to Elasticsearch.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 10:28pm UTC](https://discuss.elastic.co/t/importing-json-file-using-nest/57790/3 "2017-07-05T22:28:11Z")

</div>


