# Migrating Multiple table from SQL Server to Elasticsearch

**URL:** <https://discuss.elastic.co/t/migrating-multiple-table-from-sql-server-to-elasticsearch/110919>\
**Category:** Logstash\
**Created:** [December 9, 2017, 6:30am UTC](https://discuss.elastic.co/t/migrating-multiple-table-from-sql-server-to-elasticsearch/110919 "2017-12-09T06:30:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anshuman\_Kirty](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@Anshuman\_Kirty](https://discuss.elastic.co/u/Anshuman_Kirty)\
**Post date:** [December 9, 2017, 6:30am UTC](https://discuss.elastic.co/t/migrating-multiple-table-from-sql-server-to-elasticsearch/110919/1 "2017-12-09T06:30:18Z")

</div>

I am trying to migrate all the Tables from the database. The output received gives only the 1st Table data values in the elasticsearch. Can anyone help me. Thanks in Advance.

logstash.conf

input {  
jdbc {  
jdbc\_driver\_library =\> "C:\Users\ANSHUMAN\Desktop\mysql-connector-java-5.1.44\SQL JDBC\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc\_6.0\enu\jre8\sqljdbc42.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver://ANSHUMAN\_DEVICE\TEST\_SQL;databaseName=soc;user=sa;password=pass;"  
jdbc\_user =\> ""  
#our Query  
statement\_filepath =\> "SQLQuery2.sql"  
}  
}  
output{  
stdout { codec =\> json\_lines }  
elasticsearch{  
"hosts" =\> ["localhost:9200"]  
"index" =\> "soctest2"  
"document\_type" =\> "Tables"  
}  
}

SQLQuery2.sql

DECLARE @sqlTest VARCHAR (MAX)  
SET @sqlTest = ''  
SELECT @sqlTest = @sqlTest + 'SELECT \* FROM ' + QUOTENAME (name) + CHAR (13) from sys.tables  
EXEC (@sqlTest)

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [December 11, 2017, 6:38am UTC](https://discuss.elastic.co/t/migrating-multiple-table-from-sql-server-to-elasticsearch/110919/2 "2017-12-11T06:38:33Z")

</div>

So... use a jdbc input with the name of the second table you want to import? There is no feature to bulk-import all tables, partly because that's rarely very useful.

---

<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:** [January 8, 2018, 6:38am UTC](https://discuss.elastic.co/t/migrating-multiple-table-from-sql-server-to-elasticsearch/110919/3 "2018-01-08T06:38:47Z")

</div>

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