API to move data from SQL to Mongodb.

Question

Hello Techie,
I am trying to create API using .net.
The purpose of API is used to read data from multiple sql table and store it to respective Documents of mongodb.

The Change Data Capture feature has to be feature of API , so any change in the any column of table, can be captured and push to Mongodb.

If Any new table got created on source SQL, Data of new table can be push to New Documents of Mongodb.

May anyone please help me with such design .
Thank You So Much

Answer 1

generally sql relational schemas do not map well to document databases. you will probably need to add metadata to define this mapping.

you would use sql server data change capture to detect changes.

https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver16