How can we help you today? How can we help you today?

Have option to exclude transactions

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.
thirster42
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello,

    There is a "do not use transactions" option in SQL Compare's project settings options. That should do the trick.
    Brian Donahue
    0
  • mmJPM
    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?
    mmJPM
    0
  • James B
    Yes, you can use the "NoTransactions" option - see here
    James B
    0

Add comment

Please sign in to leave a comment.