question

ppadebettu avatar image
0 Votes"
ppadebettu asked HimanshuSinha-MSFT commented

Is it possible to replicate data from an Azure SQL Managed Instance database to an Azure Synapse database?

We are considering using Azure SQL managed instance for our OLTP applications and Azure Synapse for analytical applications. For some operational reporting use cases, we need copy of data from OLTP databases inside Azure Synapse. For these scenarios,

  • Can we use (SQL Server) replication features to replicate data from an Azure SQL Managed Instance database to an Azure Synapse database? Or is ADF Copy the only option here?

  • Will "Linked Server" option inside of Azure Synapse help with this requirement?

Thank you!

azure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ppadebettu Thanks for using Microsoft Q&A !!
I believe you need to go with ADF but I am checking internally with the products team for any other alternatives like linked servers.

0 Votes 0 ·

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered HimanshuSinha-MSFT commented

@ppadebettu I have received confirmation from products team that you can use Synapse pipeline/ADF copy activity with CDC feature to replicate the data from Azure SQL MI. Please refer to the documentation for more details.

Please let me know if you have any other questions.


Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SaurabhSharma-msft ,

We have not heard back from you on this and was just following up if you have any further queries .

Thanks
Himanshu

0 Votes 0 ·