Have option to exclude transactions

thirster42

Typically having the updates srapped in the transactions works fine. Where I run into issues is when I have a database that depends on linked servers a lot. SQL Server does not like accessing linked servers inside of a transaction. I find myself going through and manually executing each alter, create, or delete script for each individual object, and this gets a bit tedious.

It would be nice to have an option in SQL Compare to explicitly not have updates wrapped in transactions.

Brian Donahue

Hello,

There is a "do not use transactions" option in SQL Compare's project settings options. That should do the trick.

mmJPM

Brian Donahue wrote:

Hello,

There is a "do not use transactions" option in SQL Compare's project settings options. That should do the trick.

Is this option available via the command line?

James B

Yes, you can use the "NoTransactions" option - see here