Description

This error occurs because of the Transaction Isolation Level.

By default DLM Automation uses the Serializable Transaction Isolation Level, however this deployment requires a Transaction Isolation Level of Read Committed.

Workarounds

There are two alternate solutions to this issue:

1 - Use the -TransactionIsolationLevel parameter on the cmdlet (or equivalent option on the add-on) and set it to ReadCommitted

2 - Use the NoTransactions SQL Compare option
https://documentation.red-gate.com/sc13/using-the-command-line/options-used-in-the-command-line#Optionsusedinthecommandline-NoTransactions

Please note that when using NoTransactions the deployment will not be rolled back in case of error, so if you use this option it's advisable to backup first