Have option to exclude transactions
thirster42
Posts: 34
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.
It would be nice to have an option in SQL Compare to explicitly not have updates wrapped in transactions.
Comments
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?
Redgate Software