SQL Compare

Latest version: 10.0

SQL Compare

Knowledge base

Rollback on script failure or cancellation

If a synchronization script fails, or if it is cancelled, in most circumstances changes are rolled back. SQL Compare uses transactions to do this. However, there are some circumstances in which this is not possible:

  • if full-text information must be altered

    For example, within a transaction, catalogs cannot be dropped, and indexing cannot be added to a column.

  • if users and roles need to be created, altered, or deleted

    For example, within a transaction, a user cannot be created, or added to a role.

In these cases, SQL Compare rolls back all the changes that it can. Your database will be in an undetermined state and you should run another comparison.

If you have selected the project option Do not use transactions in synchronization SQL scripts to remove transactions from the synchronization SQL script, no changes are rolled back when the script fails or is cancelled. This may be useful if you want to run a script up to the point of failure, for example for debugging.

SQL Compare always warns you if it is unable to roll back changes.

Was this article helpful?

Search support
Forums
Visit the SQL Compare forum.
Learning SQL Compare
Knowledge base

SQL Compare

all SQL products

all products

Notes & articles

SQL Compare

all SQL products

all products

Demos & walkthroughs

SQL Compare