Forum Discussion

1Steveo69's avatar
1Steveo69
Copper Contributor
Dec 13, 2022

Coping data bi-directionally between Azure SQL Server and local SQL Server

Brand new to Azure. Looking to be pointed in the right direction to find information on how to update my Azure db when my local db has been written to, and also to update my local DB when the Azure D...
ericpasztor's avatar
ericpasztor
Icon for Microsoft rankMicrosoft
Dec 21, 2022

1Steveo69, to synchronize updates between 2 SQL Server instances, you would need to use Bidirectional transactional replication, which is supported across on-premise SQL Server, SQL Server Virtual Machines, SQL Server Managed Instance, but not Azure SQL Database. If your Database is hosted on a Virtual Machine or Managed Instance in Azure, the configuration steps within this article can be followed.

Resources