This error occurs because of the Transaction Isolation Level.
By default, SQL Compare uses the Serializable Transaction Isolation Level, however this deployment requires a Transaction Isolation Level of Read Committed.
This documentation goes into more detail: