API to move data from SQL to Mongodb.

Uma 421 Reputation points
2022-12-27T07:36:55.53+00:00

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

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,415 questions
Microsoft Partner Center API
Microsoft Partner Center API
Microsoft Partner Center: A Microsoft website for partners that provides access to product support, a partner community, and other partner services.API: A software intermediary that allows two applications to interact with each other.
317 questions
0 comments
Accepted answer
  1. Bruce (SqlWork.com) 56,931 Reputation points
    2023-01-03T19:57:11.27+00:00

    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

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest