# MS SQL to Elastisearch

**URL:** <https://discuss.elastic.co/t/ms-sql-to-elastisearch/151361>\
**Category:** Elasticsearch\
**Created:** [October 7, 2018, 3:34pm UTC](https://discuss.elastic.co/t/ms-sql-to-elastisearch/151361 "2018-10-07T15:34:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Haitam\_Dadsi](https://avatars.discourse-cdn.com/v4/letter/h/7ab992/32.png) [@Haitam\_Dadsi](https://discuss.elastic.co/u/Haitam_Dadsi)\
**Post date:** [October 7, 2018, 3:34pm UTC](https://discuss.elastic.co/t/ms-sql-to-elastisearch/151361/1 "2018-10-07T15:34:18Z")

</div>

Hi guys, i need to create visualizations for ms sql Data , and i found out that it is possible to duplicate data into elasticsearch , Questions : How does elasticsearch manages relations between tables ? And what are things that it offers better than just exploring using other tools ?

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [October 11, 2018, 1:10pm UTC](https://discuss.elastic.co/t/ms-sql-to-elastisearch/151361/2 "2018-10-11T13:10:44Z")

</div>

Hi @Haitam_Dadsi,

I am not sure I understand the connection between MSSQL and Elasticsearch regarding visualizations.... same goes for you statement "things that it offers better than just exploring using other tools". Can you detail?

Regarding relationships, you basically have nested documents and parent-child relationships (or [join datatype](https://www.elastic.co/guide/en/elasticsearch/reference/6.4/parent-join.html) as it called in newer ES versions). But, what I highly recommend reading is [this section of the guide](https://www.elastic.co/guide/en/elasticsearch/guide/current/relations.html) which, even if it's for older ES versions, it still applies to newer versions as well.

---

<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 8, 2018, 1:10pm UTC](https://discuss.elastic.co/t/ms-sql-to-elastisearch/151361/3 "2018-11-08T13:10:47Z")

</div>

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