Read-only database in azure cloud from on-prem database

Vujatovic, Srdjan 0 Reputation points
2023-03-13T12:36:05.7666667+00:00

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!

SQL Server on Azure Virtual Machines
Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 33,426 Reputation points MVP
    2023-03-13T14:14:34.3566667+00:00

    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.