Azure SQL sync failed due to snapshot isolation in other azure database in other region

Question

Having issues with the above.

Error Message reads ;

Sync failed with the exception "SqlException ID: 7ed05768-c403-4de2-82a6-9786fc4d2db1, Error Code: -2146232060 - SqlError Number:3952, Message: Snapshot isolation transaction failed accessing database 'TestData' because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation. For more information, provide tracing ID ‘0763be30-388e-460b-ba8d-f65594f57bc4’ to customer support."

Read all the doc and have also done the following .

using in TSQL in SSMS

ALTER DATABASE TestData
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE TestData
SET READ_COMMITTED_SNAPSHOT ON

Answer 1

SQL Data Sync is trying to enable on SQL Azure database the same isolation level your database has on premises, but it is not possible to change the isolation level of a SQL Azure database. That is the reason the SQL Data Sync process will fail.

Set the isolation level of the member database, to the same settings it has before the deployment of Data Sync. Set the isolation level to read committed (SQL Server default) or to READ_COMMITTED_SNAPSHOT.

alter database [DB] set read_committed_snapshot on with rollback immediate;