Synchronize SQL Server and Elasticsearch

Question

What is the approach of synchronizing SQL Server and elastic search, There is SQL Server as main database, and elasticsearch should be inform about any new added/updated/deleted records.

I know there was river which is deprecated, and I know logstash for exporting data from SQL Server to elasticsearch, but these can not resolve the issue.

Could anyone help?

This answer might help: stackoverflow.com/questions/34477095/… — Val
– Val, Commented Dec 19, 2017 at 8:28

dadoonet · Accepted Answer · 2017-12-19 08:29:44Z

0

I know logstash for exporting data from SQL Server to elasticsearch

Yes this is possible. Why are you saying

but these can not resolve the issue.

?

Anyway, my advice is to change the application layer if you can, and index the documents in the same "transaction" as you are modifying your data in the database.

I described this in a blog post.

answered Dec 19, 2017 at 8:29

dadoonet

14.6k3 gold badges46 silver badges51 bronze badges

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

2 Comments

Chad Over a year ago

Thank you for your response, Becuase of getting real time changes, and one important thing, you think that there are multiple local SQL server database and one central SQL Server database, also each local database has own ES and also central, and use SQL Server replication for integrating data into central database. in this case, how can resolve it in application layer?!!!!

dadoonet Over a year ago

I don't know and I probably don't understand the question TBH. But did you read my blog post?

Collectives™ on Stack Overflow

Synchronize SQL Server and Elasticsearch

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related