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.
|