Red Gate forums :: View topic - Have option to exclude transactions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Have option to exclude transactions

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
thirster42



Joined: 30 Nov 2010
Posts: 21

PostPosted: Thu Sep 29, 2011 5:05 pm    Post subject: Have option to exclude transactions Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Oct 03, 2011 11:29 am    Post subject: Reply with quote

Hello,

There is a "do not use transactions" option in SQL Compare's project settings options. That should do the trick.
Back to top
View user's profile Send private message
mmJPM



Joined: 06 Dec 2011
Posts: 4

PostPosted: Mon Dec 12, 2011 8:52 pm    Post subject: Re: Reply with quote

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?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Mon Dec 12, 2011 9:40 pm    Post subject: Reply with quote

Yes, you can use the "NoTransactions" option - see here
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group