Does azure SQL server in the VM support transactions are synchronized at various sites

Question

Dear

Whether the Azure SQL Server in the VM supports data synchronization across sites？

We have serval servers; one is the azure VM, Others are the local servers.

We deployed the SQl server in the azure VM as the data central server. Please refer to the following picture.

We use the transaction synchronization function of the SQL server. When we deploy data synchronization between multiple points, the data in the database will roll back.

When we deploy data synchronization between azure server and one local server, the data in the database will work normally.

My question is ：Does azure SQL server in the VM support transactions are synchronized at various sites？ Or it is the limitation?

hub database has the following limitation.

The hub database is a sync topology's central endpoint, in which a sync group has multiple database endpoints. All other member databases with endpoints in the sync group, sync with the hub database.

For the sql server in the azure VM has the same limitation or not

Answer 1

SQL Server in an Azure VM is just the same thing as an on-prem SQL Server. There may be smaller differences when it comes to Azure-related services, since different agents may be running in the OS, but this has nothing to do with Replication.

As for "When we deploy data synchronization between multiple points, the data in the database will roll back.", we would need to know more about your setup, which type of Replication you are using etc.