What are the challenges you face when working across database platforms? Take the survey
Options

Sync script is one big transaction

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited March 4, 2005 1:20PM in SQL Compare Previous Versions
Hello Colleen,

SQL Compare wraps all of the actions it needs to do to migrate the new schema in one large transaction, that way if an error is encountered the entire script's actions will be rolled back and the database will be left in the original state.

There is an option in SQL Compare called 'do not include plumbing for transactions', which will do away with the transactions altogether. Maybe this would be beneficial in your case.
This discussion has been closed.