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!