# Bulk insert of tables

**URL:** <https://discuss.elastic.co/t/bulk-insert-of-tables/110065>\
**Category:** Logstash\
**Created:** [December 3, 2017, 5:51pm UTC](https://discuss.elastic.co/t/bulk-insert-of-tables/110065 "2017-12-03T17:51:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pragadeesh\_dharsha](https://avatars.discourse-cdn.com/v4/letter/p/c57346/32.png) [@pragadeesh\_dharsha](https://discuss.elastic.co/u/pragadeesh_dharsha)\
**Post date:** [December 3, 2017, 5:51pm UTC](https://discuss.elastic.co/t/bulk-insert-of-tables/110065/1 "2017-12-03T17:51:05Z")

</div>

how to import a complete database into elasticsearch at once?

---

<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 4, 2017, 7:09am UTC](https://discuss.elastic.co/t/bulk-insert-of-tables/110065/2 "2017-12-04T07:09:07Z")

</div>

Technically a bunch of jdbc inputs would do it, but it's probably not what you want to do. In relational databases normalization is key and joins are necessary but in Elasticsearch data is typically stored denormalized since joins are not available. Hence, you have to store data differently and a bulk-import of tables is probably not the right solution.

---

<div class="post-metadata">

**Author:** ![pragadeesh\_dharsha](https://avatars.discourse-cdn.com/v4/letter/p/c57346/32.png) [@pragadeesh\_dharsha](https://discuss.elastic.co/u/pragadeesh_dharsha)\
**Post date:** [December 5, 2017, 6:53am UTC](https://discuss.elastic.co/t/bulk-insert-of-tables/110065/3 "2017-12-05T06:53:00Z")

</div>

can i make elastic search as a primary data storage like rdbms?

---

<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 5, 2017, 6:54am UTC](https://discuss.elastic.co/t/bulk-insert-of-tables/110065/4 "2017-12-05T06:54:31Z")

</div>

Elasticsearch can be a primary data store, yes. Whether it's a good idea in your case is harder to answer.

---

<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 2, 2018, 6:55am UTC](https://discuss.elastic.co/t/bulk-insert-of-tables/110065/5 "2018-01-02T06:55:42Z")

</div>

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