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