# Is Elastic Search suitable for searching text in all tables?

**URL:** <https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492>\
**Category:** Elasticsearch\
**Created:** [August 2, 2019, 9:24am UTC](https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492 "2019-08-02T09:24:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yasir\_Arafat](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yasir_arafat/32/48857_2.png) [@Yasir\_Arafat](https://discuss.elastic.co/u/Yasir_Arafat)\
**Post date:** [August 2, 2019, 9:24am UTC](https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492/1 "2019-08-02T09:24:33Z")

</div>

I have question about Elastic Search is that I have Sql Server Database and i have to **Search all tables for text** for this purpose Elastic search feature is good enough or i have to go with other option.

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [August 2, 2019, 10:29am UTC](https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492/2 "2019-08-02T10:29:48Z")

</div>

Hey,

it's a common use-case to index data from a SQL server into Elasticsearch in order to leverage Elasticsearch for full-text search. I did this for a ecommerce product search engine in my previous job and it worked great.

It is very hard to tell if this is `good enough` in your use-case, as the definition of good may be vastly different for anyone asking such a question. Are you referring to a faster search, are you referring to language dependent search. Maybe you can be more exact about your requirements.

--Alex

---

<div class="post-metadata">

**Author:** ![Yasir\_Arafat](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yasir_arafat/32/48857_2.png) [@Yasir\_Arafat](https://discuss.elastic.co/u/Yasir_Arafat)\
**Post date:** [August 2, 2019, 10:41am UTC](https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492/3 "2019-08-02T10:41:57Z")

</div>

Thanks a lot for such a response i will try by best to define my case.  
I have to search almost 16 tables in each table there is up to 4 columns for which i have to search the specific keyword currently i am doing this using joins so is it suitable for me and what is the possibility to do in elastic and it will give me efficient and fast response.  
I am sharing my Query with you you can check it by downloading from url given below.

> **[SqlQueryElastic.sql](https://drive.google.com/file/d/15cCJbyCwivlm1wC9IaNc1ZoWT8nrJKWn/view?usp=sharing)**
>
> Google Drive file.

and please can you assist me how to execute sp with input parameters in elastic search.

---

<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:** [August 30, 2019, 10:42am UTC](https://discuss.elastic.co/t/is-elastic-search-suitable-for-searching-text-in-all-tables/193492/4 "2019-08-30T10:42:07Z")

</div>

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