Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQL Server to Oracle Migration overview.

Ispirer SQLWays Database Migration Software

Starting Transaction

Some databases allow explicit creation of user-defined transaction by special statements. When such statement database is defined a new user-defined transaction starts.

TABLE 47. Starting Transaction

Database	Syntax	Description
Microsoft SQL Server	BEGIN [ TRAN [ SACTION ] [ transaction_name | @tran_name_variable ] [ WITH MARK [ 'description' ] ] ]	BEGIN TRANSACTION starts an explicit or nested local transaction for the connection issuing the statement. Each transaction continues either until it completes without errors and COMMIT TRANSACTION ends transaction, or if errors are encountered and all modifications are erased with a ROLLBACK TRANSACTION statement. BEGIN TRANSACTION increments @@TRANCOUNT by 1. The WITH MARK option is the transaction name which places in the transaction log. When restoring a database to an earlier state, the marked transaction can be used in place of a date and time.
Oracle	Not supported.