Importing JSON file using NEST

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.

Thanks in advance.

Using Logstash for this is one option, with the jdbc plugin.

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 to hydrate records into POCOs), and then use NEST to send bulk requests of batches of documents to Elasticsearch.