title: Data transfer from SQL Server to ElasticSearch Node
body: <p>I was using Elastic Search 1.7 version for my application and  by using the concept of river i was filling up the data from SQL Server to ElasticSearch using the following article : <a href="https://www.pluralsight.com/blog/it-ops/elasticsearch-and-sql-server" rel="noreferrer">https://www.pluralsight.com/blog/it-ops/elasticsearch-and-sql-server</a></p>
  
  <pre><code>URL: POST http://localhost:9200/_river/my_jdbc_river/_meta
  
  JSON:
  
  {
  
  "type":"jdbc",
  
  "schedule" : "0 0-59 0-23 ? * *",
  
  "jdbc": {
  
  "driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",
  
  "url":"jdbc:sqlserver://127.0.0.1:1433;databaseName=MyDatabase",
  
  "user":"my_db_user","password":"password",
  
  "sql":"select ID as _id, FirstName, LastName, DateOfBirth from People",
  
  "index":"people",
  
  "type":"person"
  
  }
  
  }
  </code></pre>
  
  <p>But in the documentation of elastic search 2.0 it says the rivers are deprecated .Is there any better way to copy the data from SQL Server to elastic with elastic search 2.0</p>
  
  <p>Any code sample of alternative would be really helpful</p>
  
  <p>Thanks</p>