# Load sql server data into elasticsearch without query

**URL:** <https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query/153558>\
**Category:** Logstash\
**Created:** [October 23, 2018, 9:32am UTC](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query/153558 "2018-10-23T09:32:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [October 23, 2018, 9:32am UTC](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query/153558/1 "2018-10-23T09:32:46Z")

</div>

Hello,  
I want to load all the tables along with the data present within the database schema, without using query.

With query we can load data from sql server from multiple tables into elasticsearch as shown in below example.  
But i need to load all the tables from sql server by mentioning the database schema, username and password.  
Is this possible? Please help me.

Ex:  
input {

jdbc {  
jdbc\_driver\_library =\> "C:/Users/xxxx/Downloads/sqljdbc4-2.0.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://localhost:1433;user=qqqq;password=vvvv@123;database=QWEQWE"  
jdbc\_user =\> "qqqq"  
jdbc\_password =\> "vvvv@123"  
statement =\> "SELECT TOP 1000 \* FROM SAMPLE"  
jdbc\_paging\_enabled =\> "true"  
jdbc\_page\_size =\> "50000"  
}

}

I need all tables data without "statement" tag(query) and retrive all tables data.

Is this possible? Thanks in advance.

---

<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:02am UTC](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query/153558/2 "2018-10-23T10:02:31Z")

</div>

This seems to be a duplicate of [this issue](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query-using-logstash/153557/2). Please do not open multiple threads for the same question/issue.

---

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [October 23, 2018, 10:06am UTC](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query/153558/3 "2018-10-23T10:06:14Z")

</div>

sorry, this happened by mistake,

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 20, 2018, 10:06am UTC](https://discuss.elastic.co/t/load-sql-server-data-into-elasticsearch-without-query/153558/4 "2018-11-20T10:06:14Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.