Sync script is one big transaction
Brian Donahue
Posts: 6,590 Bronze 1
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.
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.
