Please consider Azure SQL Managed Instance Link feature as a possible solution on your scenario. You can use the link feature to replicate data one way from a SQL Server instance to an Azure SQL Managed Instance. You can replicate whole databases at nearly real-time to Azure.
Read-only database in azure cloud from on-prem database
Vujatovic, Srdjan
0
Reputation points
Hello,
Can you provide me a way to sync full database and have read only version of on-prem database on azure cloud?
Seems like High Availability is not working, there are Data Sync / replication options but they are only table level.
I want full database synchronization, something like HA, Mirroring or log shipping.
Thanks in advance for suggestions!