Subscriber Configuration - SQL Data Sync

Question

I have a SQL 2019 transactional replication subscriber DB and I would like to change its isolation level to facilitate SQL Data Sync to an Azure instance. (I can’t do it from the publisher and I do realize that would be easiest…but not an option.)

My question is: will updating the DB to have a new transaction isolation level (I don’t need snapshot isolation) cause any problems for transactional replication?

Answer 1

Hi,

Welcome to Microsoft Q&A!

The Distribution Agent uses regular TSQL commands and transactions to apply changes from the distribution database to the subscribers.

If there are report service or other activities on this subscriber, depending on the isolation level of the database you change, this may indeed have some impact, such as dirty reads.