# How to export SQL Server Data to Elasticsearch 6.0.0
**URL:** https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137
**Category:** Elasticsearch
**Created:** [December 25, 2017, 9:03am UTC](https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137 "2017-12-25T09:03:55Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@kartheek91](https://discuss.elastic.co/u/kartheek91)
#### Post date: [December 25, 2017, 9:03am UTC](https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137/1 "2017-12-25T09:03:55Z")
Guys I'm trying get the data from sql server 2014 to Elasticsearch 6.0.0 .Please let me know the best possible scenarios.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 25, 2017, 9:20am UTC](https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137/2 "2017-12-25T09:20:02Z")
We aren't all guys 🙂
Have you looked at [https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html)?
---
### Author:  [@kartheek91](https://discuss.elastic.co/u/kartheek91)
#### Post date: [December 25, 2017, 9:25am UTC](https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137/3 "2017-12-25T09:25:38Z")
It is showing us MYSQL plugin does it support sql server.What I'm thinking was we have sql server database where data is getting inserted [daily.So](http://daily.So) I need to run a cron job to sync sql server database to elasticsearch.
So can you tell me how the above mentioned article will work.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 25, 2017, 9:31am UTC](https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137/4 "2017-12-25T09:31:08Z")
If your SQL server supports JDBC then you can use that.
---
### Author:  [@kartheek91](https://discuss.elastic.co/u/kartheek91)
#### Post date: [December 25, 2017, 9:43am UTC](https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137/5 "2017-12-25T09:43:46Z")
No Actually we are using sql server 2014 which doesn't support JSON
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 22, 2018, 9:44am UTC](https://discuss.elastic.co/t/how-to-export-sql-server-data-to-elasticsearch-6-0-0/113137/6 "2018-01-22T09:44:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.