SwisSQL - DB2 to Oracle Migration Tool helps
you migrate IBM DB2 SQL Procedures, Functions
and Triggers to Oracle PL/SQL Stored Procedure
language. When enterprises migrate from IBM DB2
UDB to Oracle, application migration is one of
the tedious tasks and there are no good tools
which can ease the process of migrating DB2 SQL
Stored Procedures to Oracle PL/SQL Stored Procedures.
Using SwisSQL - DB2 to Oracle Migration Tool and
through AdventNet's superior support, enterprises
can realize significant time and cost savings
during the migration and testing process.
Procedures, Functions, Triggers, Tables,
Views and other database objects from DB2 SQL
to Oracle PL/SQL.
DB2 SQL built-in and user-defined datatypes
to Oracle PL/SQL.
DB2 SQL built-in functions into corresponding
PL/SQL functions.
Cursor Declaration, OPEN, FETCH, CLOSE Statements.
Result-Set processing from DB2 SQL to Oracle
PL/SQL.
SET assignment statement.
DB2 SQL Conditional and Control statements.
DB2 SQL Labels and GOTO statement.
Transaction statements such as 'COMMIT',
'ROLLBACK' and 'SAVEPOINT'.
DB2 SQL Temporary Tables.
DB2SQL Associate and Allocate Cursor statements.
DB2 SQL Get Diagnostics statements.
DB2 SQL EXECUTE and EXECUTE IMMEDIATE statements.
Values Into Statement.
DB2 EXISTS clause to Oracle.
DB2 SQL queries to Oracle SQL queries.
DB2_TOKEN_STRING and MESSAGE_TEXT constructs
in Get Diagnostics statement.
DMLs and Cursors with isolation levels.
Exception handlers like CONTINUE and EXIT
handlers.
Almost all other DB2 SQL syntaxes into Oracle
PL/SQL.
SwisSQL DB2 to Oracle Migration Tool GUI
Features:
Provides an Intuitive and Easy to use GUI
for handling the migration.
One click conversion of DB2 SQL to Oracle
PL/SQL.
Provides a tree view of loaded DB2 SQL files
and converted Oracle PL/SQL files.
Options to load DB2 SQL files from local directory
or import them from DB2 database for Oracle
PL/SQL conversion.
Project driven organization to ease maintenance.
Generates formatted Oracle PL/SQL code with
comments.
Comprehensive migration reports with detailed
information such as total number of files loaded,
total number of files converted, total number
of files not converted, destination directory
of converted files.
Provides a unified view with loaded DB2 SQL
file, converted Oracle PL/SQL file, log report
and error reports.
Provision to compile the converted Oracle
PL/SQL code.
