Hi @NagaSri ,
Thank you for posting your query on Microsoft Q&A Platform.
You can leverage Synapse Pipelines or Azure data factory pipelines to incrementally load On-primes DB in to Synapse.
Please check below documentation links which helps you figure out logic of implementation for same.
- Incrementally load data from a source data store to a destination data store
- Incrementally load data from multiple tables in SQL Server to a database in Azure SQL Database using the Azure portal
- Incrementally load data from Azure SQL Database to Azure Blob storage using the Azure portal
Please Note:
- To connect with on-prem data you need to configure self-hosted IR. Click here to know more about it.
- You need consider on-prem data as your source and Synapse as your sink in all above documentations logic.
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators