SwisSQL – DB2 to Oracle Edition

SwisSQL – DB2 to Oracle Edition

SwisSQL - DB2 to Oracle Edition

Developer’s Description

By Zoho
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. SwisSQL – DB2 to Oracle Migration Tool ease the process of migrating DB2 SQL Stored Procedures to Oracle PL/SQL Stored Procedures.It converts Procedures, Functions, Triggers, Tables, Views and other database objects from DB2 SQL to T-SQL and also converts Cursor Declarations, OPEN, FETCH, and CLOSE statements and almost all other DB2 SQL syntaxes into Oracle PL/SQL

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 ZOHO Corporation’s superior support, enterprises can realize significant time and cost savings during the migration and testing process.

SwisSQL DB2 to Oracle Migration Tool converts

 SwisSQL DB2 to Oracle Migration Tool
SwisSQL DB2 to Oracle Migration Tool Supported Databases

Want to Migrate
Data too ?
SwisSQL
Data Migration
Migrate Schema and Data from
DB2 to Oracle.
More Info SwisSQL Data Migration Tool More Info
Download SwisSQL Data Migration Tool Download
  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.
 

 

Automated migration tool to convert Oracle PL/SQL to IBM DB2 UDB SQL

SwisSQL – Oracle to DB2 Edition is an automated migration tool to convert stored procedures implemented in Oracle PL/ SQL code into equivalent IBM DB2 SQL.   SwisSQL – Oracle to DB2 Migration Tool automates over 80% of the Oracle PL/SQL code conversion into IBM DB2 with little to none manual interventions.

SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time

Limitations in the unregistered version

  • 30 days Trial
  • The tool can be used to convert up to 2000 lines of PL/SQL stored procedures to DB2SQL stored procedures.

Publisher Description

 

SwisSQL – Oracle to DB2 Edition is an automated migration tool to convert stored procedures implemented in Oracle PL/ SQL code into equivalent IBM DB2 SQL. It automates more than 80% of the Oracle PL/SQL code conversion into IBM DB2 with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time.
Features
* Migration of Oracle PL/ SQL procedures, functions, triggers, cursors, tables and views into TransactSQL
* Support for conversion of PL/ SQL In-Built Functions, Datatypes, and SQL Queries
* Support for conversion of all Transaction features.
* Support for conversion of PL/ SQL cursor variables, attributes & implicit cursors into Transact SQL.
* Support for conversion of PL/ SQL labels, conditional, control and record statements.
* Support for conversion of Sub Procedures and Sub Functions defined in declaration section of PL/SQL Block.
* Generation of formatted, readable DB2 SQL code with good comments.
* Support for Native Dynamic SQL Statements(NDS) conversion.
* A user friendly Graphical user interface with support for:
o One click conversion of PL/ SQL into DB2 SQL.
o Fetching PL/ SQL model from database directly and converting. Also supports conversion of source files from local directory.
o Project driven organization of converted code to ease maintenance.

About SwisSQL – Oracle to DB2 Migration Tool

SwisSQL – Oracle to DB2 Migration Tool is a free trial software published in the Other list of programs, part of Development.

This program is available in English. It was last updated on 2019-06-15. SwisSQL – Oracle to DB2 Migration Tool is compatible with the following operating systems: Windows.

The company that develops SwisSQL – Oracle to DB2 Migration Tool is ZOHO Corporation. The latest version released by its developer is 3.1. This version was rated by 1 users of our site and has an average rating of 4.0.

SwisSQL – DB2 to Oracle Migration Tool helps to migrate from IBM DB2 SQL Procedures, Functions and Triggers to Oracle PL/SQL Stored Procedure language. When companies migrate from IBM DB2 UDB to Oracle, application migration is one of the tedious tasks. SwisSQL – DB2 to Oracle migration tool ease the process of migrating from DB2 SQL Stored Procedures to Oracle PL/SQL Stored Procedures.It converts procedures, functions, triggers, tables, views and other database objects to DB2 SQL to T-SQL and also converts Cursor Statements, OPEN, FETCH and CLOSE and almost all other DB2 SQL syntax to Oracle PL/SQL.

DB2-to-Oracle Convertor
This chapter describes the DB2 objects that are migrated from the source platform (z/OS) and the migration tools that are generated. The conversion is performed in the context of other components translated or generated by the other Oracle Tuxedo Application Rehosting Workbench tools.
This chapter contains the following topics:
•
Overview of the DB2-to-Oracle Convertor
•
Description of the Input Components
•
Description of the Output Files
•
Detailed Processing
Overview of the DB2-to-Oracle Convertor
Purpose
The purpose of this section is to describe precisely all the features of the Rehosting Workbench DB2-to-Oracle Convertor tools including:
•
Inventory of DB2 objects migrated.
•
Detailed description of converted Oracle objects on the target platform for each DB2 object.
•
Description of the different commands to be used with the DB2-to-Oracle Convertor.
•
Description of the data unloading options on the source platform.

 

•
Description of the data loading options on the target platform.

SwisSQL – Oracle to DB2 Edition is an automated migration tool to convert stored procedures implemented in Oracle PL/ SQL code into equivalent IBM DB2 SQL. It automates more than 80% of the Oracle PL/SQL code conversion into IBM DB2 with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time.

Features

* Migration of Oracle PL/ SQL procedures, functions, triggers, cursors, tables and views into TransactSQL
* Support for conversion of PL/ SQL In-Built Functions, Datatypes, and SQL Queries
* Support for conversion of all Transaction features.
* Support for conversion of PL/ SQL cursor variables, attributes & implicit cursors into Transact SQL.
* Support for conversion of PL/ SQL labels, conditional, control and record statements.
* Support for conversion of Sub Procedures and Sub Functions defined in declaration section of PL/SQL Block.
* Generation of formatted, readable DB2 SQL code with good comments.
* Support for Native Dynamic SQL Statements(NDS) conversion.
* A user friendly Graphical user interface with support for:
o One click conversion of PL/ SQL into DB2 SQL.
o Fetching PL/ SQL model from database directly and converting. Also supports conversion of source files from local directory.
o Project driven organization of converted code to ease maintenance.

Leave a Reply

Your email address will not be published. Required fields are marked *