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