How to copy sql db to Elasticsearch using sql query

See more:

SQL

Elasticsearch

Hi Friend's,

I have created web service using web api. In this application i want to use fulltext search concept. so for this will go for elasticsearch concept, for this concept implementation first i need to copy sql database specific table data into elasticsearch using river, index and type using post man. this i am doing one by one using post man. now i want to avoid this data copy concept using post man. Is there any other way to copy bulk data (single time) from sql to elasticsearch using sql job or any other logic.
So please can any one suggest me on this..


Thanks in Advance,
Mohan G