Red Gate forums :: View topic - Toolkit - rollback
Return to www.red-gate.com RSS Feed Available

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

Toolkit - rollback

Search in SQL Toolkit Previous Versions forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
npaterson



Joined: 02 Oct 2007
Posts: 6

PostPosted: Tue Oct 02, 2007 7:53 pm    Post subject: Toolkit - rollback Reply with quote

Can anyone tell me if when you're using the toolkit compare api if you can rollback changes if you detect an error?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Fri Oct 05, 2007 5:35 pm    Post subject: Reply with quote

Hi,

The script output produced by SQL Toolkit is broken into transaction batches, so if one particular batch fails, the entire script rolls back to the start. This is also the default behavior if you let SQL Compare /Data Compare engines run the synchronization script for you. If this is a Packager API project, be aware that if the data script needs to roll back, the schema script had already been committed.

If you want to change the scripts so that any script errors will not roll back, set the NoSqlPlumbing option in SQL Compare and unset the UseTransactions option in the SessionSettings enumeration of the Data Compare Engine.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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