This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 81%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Im using an sql server in my on premise with version 2019, I need to transfer or replicate real time data to azure synapse database, so which azure service will be more effective and flexible for large data transfer
Below blog explains the scenario in detail :
where you can create a linked server and trigger the sync
Hi Nandan,
I have tried your method to replicate data from sql server to synapse, during the creation we ended up in error while creating trigger in adf. Can you please help on this
Regards
AGP
I guess that Nandan will appreciate if you disclose the text of the error message or show a screenshot of it.
Hi，AGP
In addition to the pipeline technology of Azure Data Factory, there is another one that I recommend you can try.
This is the official introduction and usage details for pipeline technology：
https://video2.skills-academy.com/en-us/azure/data-factory/connector-sql-server?tabs=data-factory
Regards
Mikey Qiao
If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.