# Load sql server data into elasticsearch without query using logstash

**URL:** <https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query-using-logstash/153557>\
**Category:** Logstash\
**Created:** [October 23, 2018, 9:31am UTC](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query-using-logstash/153557 "2018-10-23T09:31:00Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [October 23, 2018, 10:01am UTC](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query-using-logstash/153557/2 "2018-10-23T10:01:22Z")

</div>

Logstash only supports moving data by querying over JDBC. I am not aware of any solution that replicates all tables in a database, and even if such a solution existed, you probably would want to restructure your data into a document-centric model before you move the data as Elasticsearch is not a relational system and does not support joins.

---

_[View the full topic](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query-using-logstash/153557)._