Setting transaction isolation level SQLCompare.exe (SQL Compare 14) Command line utility

VenkatM

We would like to set Transaction Isolation Level to READ COMMITTED when using the command line utility (SQLCompare.exe) to generate scripts. The default is SERIALIZABLE.
Can I leverage the SQLCompare.exe.config file to set this?

Kurt_M

To anyone else looking for this information, the following documentation should give you the information you require:
https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line#Switchesusedinthecommandline-/TransactionIsolationLevel:%3Ctransactionisolationlevel%3E:~:text=syncScriptEncoding%3AASCII-,/TransactionIsolationLevel%3A%3Ctransaction%20isolation%20level%3E,-Alias%3A%C2%A0/til
 
Essentially, you only need to use the /TransactionIsolationLevel:<transaction isolation level> command within your command line script. The options are:

• READ UNCOMMITTED
• READ COMMITTED
• REPEATABLE READ
• SNAPSHOT
• SERIALIZABLE