| Author |
Message |
thirster42
Joined: 30 Nov 2010
Posts: 21
|
 Posted: Thu Sep 29, 2011 5:05 pm Post subject: 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. |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
|
| Posted: Mon Oct 03, 2011 11:29 am Post subject: |
|
|
Hello,
There is a "do not use transactions" option in SQL Compare's project settings options. That should do the trick.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
mmJPM
Joined: 06 Dec 2011
Posts: 4
|
| Posted: Mon Dec 12, 2011 8:52 pm Post subject: Re: |
|
|
| 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 |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 844
Location: My desk.
|
| Posted: Mon Dec 12, 2011 9:40 pm Post subject: |
|
|
| Yes, you can use the "NoTransactions" option - see here |
|
| Back to top |
|
|
|
|
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
