Toolkit - rollback

Forum for users of SQL Toolkit 3,4,and 5

Toolkit - rollback

Postby npaterson » Tue Oct 02, 2007 7:53 pm

Can anyone tell me if when you're using the toolkit compare api if you can rollback changes if you detect an error?
npaterson
 
Posts: 6
Joined: Tue Oct 02, 2007 3:41 pm

Postby Brian Donahue » Fri Oct 05, 2007 5:35 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Toolkit Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests