Have option to exclude transactions

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Have option to exclude transactions

Postby thirster42 » Thu Sep 29, 2011 5:05 pm

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
 
Posts: 21
Joined: Tue Nov 30, 2010 11:36 pm

Postby Brian Donahue » Mon Oct 03, 2011 11:29 am

Hello,

There is a "do not use transactions" option in SQL Compare's project settings options. That should do the trick.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby mmJPM » Mon Dec 12, 2011 8:52 pm

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?
mmJPM
 
Posts: 4
Joined: Tue Dec 06, 2011 10:23 pm

Postby james.billings » Mon Dec 12, 2011 9:40 pm

Yes, you can use the "NoTransactions" option - see here
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests