How can I use elasticsearch with the data on ms sql?

Question

my data is on Sql server and I want to use ElasticSearch.

Does ElasticSearch mean that there will also be a copy of the data?

Thank you.

Amit · Accepted Answer · 2020-07-27 09:52:42Z

1

First Elasticsearch and SQL is totally independent databases and there is no relation in them. ms sql is relational database while Elasticsearch is search database which is document based.

People uses RDBMS as source of truth and build Elasticsearch to serve the search and analytics application and it all depends on you how you want to populate your elasticsearch and keep the data in your SQL and Elasticsearch.

You can have Elasticsearch without any backing RDBMS.
You can have both and choose to delete data from SQL once copied to Elasticsearch or have the data in both databases.

answered Jul 27, 2020 at 9:52

Amit

32.5k7 gold badges68 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fatih Erol Over a year ago

Thank you for your answer. I was thinking of Elasticsearch as a search engine. Now I am learning that there is a database. I am already using MongoDB. Should I use elasticsearch for speed dials?

Collectives™ on Stack Overflow

How can I use elasticsearch with the data on ms sql?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related