SwisSQL - DB2 to Oracle Migration Tool 1.5

Migrate IBM DB2 UDB SQL to Oracle PL/SQL

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.

SwisSQL DB2 to Oracle Migration Tool converts

1. Procedures, Functions, Triggers, Tables, Views and other database objects from DB2 SQL to Oracle PL/SQL.
2. DB2 SQL built-in and user-defined datatypes to Oracle PL/SQL.
3. DB2 SQL built-in functions into corresponding PL/SQL functions.
4. Cursor Declaration, OPEN, FETCH, CLOSE Statements.
5. Result-Set processing from DB2 SQL to Oracle PL/SQL.
6. SET assignment statement.
7. DB2 SQL Conditional and Control statements.
8. DB2 SQL Labels and GOTO statement.
9. Transaction statements such as 'COMMIT', 'ROLLBACK' and 'SAVEPOINT'.
10. DB2 SQL Temporary Tables.
11. DB2SQL Associate and Allocate Cursor statements.
12. DB2 SQL Get Diagnostics statements.
13. DB2 SQL EXECUTE and EXECUTE IMMEDIATE statements.
14. Values Into Statement.
15. DB2 EXISTS clause to Oracle.
16. DB2 SQL queries to Oracle SQL queries.
17. DB2_TOKEN_STRING and MESSAGE_TEXT constructs in Get Diagnostics statement.
18. DMLs and Cursors with isolation levels.
19. Exception handlers like CONTINUE and EXIT handlers.
20. 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.

Supported Database Versions