1

Is there a way to sync NoSQL and SQL databases?

My problem is: We have a software that uses MSSQL. We also have a mobile application that uses MongoDB. We want to sync data (on create/update) between those databases. Mostly from MongoDB to MSSQL.

It is not a problem for us (if we have to) to use different NoSQL DBMs, but we can't find clear instructions of how to sync those two the way i described.

Can anyone help? Thanks.

italomarca
  • 33
  • 5
  • 1
    Possible duplicate of [Is it possible to migrate data from MongoDB to SQL-Server?](https://stackoverflow.com/questions/29986360/is-it-possible-to-migrate-data-from-mongodb-to-sql-server) – FLICKER Dec 29 '17 at 20:47

1 Answers1

0

Have you looked at CDC (Change Data Capture) tools that allow you to capture events from your source database (in this case MSSQL) and deal with the event to update/create/delete data in the NoSQL database.

I invite you to look at https://debezium.io/ and the MSSQL Connector & MongoDB connector:

Tug Grall
  • 3,410
  • 1
  • 14
  • 16