Migrate Oracle PL/SQL to IBM DB2 UDB SQL
SwisSQL - Oracle to DB2 Migration Tool helps
you migrate Oracle PL/SQL Packages, Procedures,
Functions and Triggers to IBM DB2 Stored Procedure
language. When enterprises migrate from Oracle
to DB2, application migration is one of the tedious
tasks and there are no good tools which can ease
the process of migrating Oracle Stored Procedures
to DB2 Stored Procedures. Using SwisSQL - Oracle
to DB2 Migration Tool and through AdventNet's
superior support, enterprises can realize significant
time and cost savings during the migration and
testing process.
SwisSQL Features: SwisSQL Oracle to DB2 Migration
Tool converts |
- Support for NestedTable and Varray Collection
types.
- Support for conversion of package variables.
- Support for conversion of implicit datatype
conversion done by Oracle.
- Support for truncating variable names if
the length exceeds the permitted value.
- Support for conversion of UTL_FILE package.
- Support for conversion of TO_DATE, TO_CHAR,
SUBSTR, LAST_DAY, MONTHS_BETWEEN, ADD_MONTHS,
TRUNC, ROUND, INSTRB, TRIM built-in functions.
- Support for Conversion of PL/SQL Procedures,
Functions, Triggers, Packages etc. to DB2.
- Support for Conversion of ORACLE Datatypes
TO DB2.
- Support for PL/SQL Functions conversion into
DB2.
- Support for ORACLE SQL queries conversion
into DB2 SQL Queries.
- Support for Cursor Declaration, OPEN, FETCH
and CLOSE Statements Conversion.
- Support for conversion of Cursor Variables.
- Support for Implicit Cursor Conversions.
- Support for PL/SQL Conditional Statements
conversion.
- Support for PL/SQL Control Statements conversion.
- Support for Native Dynamic SQL Statements(NDS)
conversion.
- Support for %ROWCOUNT, %FOUND and %NOTFOUND
cursor attributes.
- Support for PL/SQL Label Conversions.
- Support for PL/SQL Record Statements.
- Transaction features Conversion for 'COMMIT',
'ROLLBACK', 'SAVEPOINT' etc. are supported.
- AssociativeArrays with INDEX BY Binary_Integer
is supported.
- Support for sub procedures defined in declaration
section of PL/SQL Block(LocalModules).
- Support for Record insert and update in DML
Statements.
- Support for SubFunctions defined in the declaration
section of another PL/SQL block
- Anonymous PL/SQL block are now supported.
- RETURNING..INTO clause is supported in DML
statements.
- Oracle To DB2 datatypes are made configurable
allowing users to specify equivalent DB2 datatype
for each Oracle Datatype.
- Support for ROWID and SYS_GUID conversion.
- Support for LEAST, GREATEST Functions.
- Comprehensive reports for each and every
conversion performed using the tool.
- Provision to compile the generated DB2SQL
code from with in the tool.
- Configurable option to customize the conversion
of PL/SQL Functions into equivalent DB2 Procedures.
- A user friendly Graphical user interface
with support for:
- One click conversion of PL/SQL into DB2SQL
.
- Fetching PL/SQL model from database directly
and converting. Also supports conversion
of source files from local directory.
- Project driven organization of converted
code to ease maintenance.
- Support for conversion of Recursive Procedure
and Function call made within a PL/SQL procedure
or function.
- Support for Oracle Hierarchical queries (START
WITH.. CONNECT BY clause) conversion.
- Support for converting exponentiation (**)
operator.
SwisSQL Oracle to DB2 Migration Tool GUI Features:
- Provides an Intuitive and Easy to use GUI
for handling the migration.
- One click conversion of PL/SQLs to DB2 SQL.
- Provides a tree view of loaded PL/SQL files
and converted DB2 SQL files.
- Options to load PL/SQL files from local directory
or import them from Oracle database for DB2
SQL conversion.
- Project driven organization to ease maintenance.
- Generates formatted DB2 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 PL/SQL
file, converted DB2 SQL file, log report and
error reports.
- Provision to compile the converted DB2 SQL
code.
|
Supported
Database Versions |
| Source
Database |
Target
Database |
Oracle
8.1.6, 8.1.7, 9i, and 10g
|
IBM
DB2 UDB 8.x |
|
|
Download
SwisSQL - Oracle to DB2 Migration Tool
|
|
|
