Using Transactions

dbForge Fusion allows to control data editing with transactions. You can access the following buttons on the Connection toolbar: Begin Transaction, Commit, and Rollback.

Click on Begin Transaction button on the Connection toolbar or select Begin Transaction from the shortcut menu of the connection to start a new transaction. Since now all changes you make to a database object are not applied until you click Commit button on the Connection toolbar or select Commit from the shortcut menu of the connection. To revert all changes and return to the point where you have been at the moment of clicking Begin Transaction button, click on the Rollback button on the Connection toolbar or select Rollback from the the shortcut menu of the connection.

Commit is automatically issued when you save documents that represent database objects.

The transaction applies to the whole connection. Notice that the Output window reports all transaction events.