Transaction support

The code viewer of AdeptSQL Diff supports transactions. It means that the program remembers the position in the script where the transaction has started and returns the execution pointer there if the transaction gets rolled back due to an error. When a SQL statement such as {BEGIN | COMMIT | ROLLBACK} TRAN[SACTION] is executed, the program recognizes that and updates its state automatically.

You can also enter or leave a transaction manually, using the (Start), (Commit) or (Rollback) buttons on the Code Viewer's toolbar.

Note: named transactions and checkpoints are not supported. When the Code Viewer executes one of those, it simply ignores any additional parameters. The command goes to the SQL server exactly as it is, but the Code Viewer remains unaware of the transaction name. If you now try to press (Rollback), the program will issue a regular unnamed "ROLLBACK TRANS" thus causing an error.

This limitation should not present a problem, as we are dealing here with straightforward DDL scripts generated by AdeptSQL Diff which usually does not put any transactions there.