How to disable writing of this lines using ExecutionBlock.GetString():
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
In SqlCompare I check "Do not use transactions in synchronisation scripts"
in SDK there no such Options.
Tried NoSQLPlumbing, but it does't work.
This is a part of another problem.
I need SQL script for changing schema and data in single transaction.