Re: converting DB2 triggers to Oracle

From: The Boss <usenet_at_No.Spam.Please.invalid>
Date: Thu, 26 Jun 2008 23:13:17 +0200
Message-ID: <4864066d$0$14347$e4fe514c@news.xs4all.nl>


--CELKO-- wrote:
> I need to convert a bunch of DB2 triggers to Oracle. Is there any
> kind of tools for this?

I think it would be more appropriate to ask this question in the Oracle group, but anyway ...

A quick Google on "migration+db2+oracle+triggers" gives a couple of possible useful links on the very first page:

  1. Oracle Migration Workbench.

<q>
The Oracle Migration Workbench is a tool that simplifies the process of migrating Informix, and DB2 databases to the Oracle platform (Oracle9i and Oracle10g). The Oracle Migration Workbench migrates the entire database schema, including triggers and stored procedures, in an integrated environment.

To migrate Microsoft Access, Microsoft SQL Server, MySQL and Sybase databases to Oracle refer to Oracle SQL Developer, which now incorporates the Migration Workbench.
</q>
http://www.oracle.com/technology/tech/migration/workbench/index.html

B. SwisSQL - DB2 to Oracle Migration Tool 1.5

<q>
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. DMLs and Cursors with isolation levels.
  5. Exception handlers like CONTINUE and EXIT handlers.
  6. Almost all other DB2 SQL syntaxes into Oracle PL/SQL. </q> http://www.swissql.com/products/db2-to-oracle/db2-to-oracle.html Note: they also offer similar capabilities for the reverse migration: http://www.swissql.com/products/oracle-to-db2/oracle-to-db2.html
  7. Ispirer SQLWays 3.9

<q>
Database migration software for DB2, Oracle, SQL Server, Sybase and MySQL

SQLWaysT is an innovative database migration application that easily performs export (migrates all major databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase and MySQL) on one system and imports on another system and platform (Windows or Unix).

SQLWays converts tables (default values, null and identity properties, check and unique constraints, primary and foreign keys, comments), indexes, views, triggers, stored procedures and functions. Allows you to specify global data type mapping for all tables and local data type mapping for each table individually.
</q>
http://www.softpedia.com/get/Internet/Servers/Database-Utils/SQLWays.shtml [Review-site where you can download a free trial version]

<q>
We provide migration software and services for IBM DB2, Oracle, Microsoft SQL Server, Sybase, Informix, MySQL, PostgreSQL, Progress and other databases.

Our product SQLWays allows you to easily migrate data, schema, stored procedures, triggers and other objects between different databases. [...]
SQLWays automates the entire migration process transferring data, database schema, business logic (stored procedures, functions and triggers). It automatically handles all changes between interdependent objects and facilitates the application conversion requiring minimum resources and time to complete a migration project.
</q>
http://www.ispirer.com/

This should get you started, I guess...
Disclaimer: No experience with any of these tools, no stakes in any of the companies either ;-)

HTH [added c.d.o.s.]

-- 
Jeroen 
Received on Thu Jun 26 2008 - 16:13:17 CDT

Original text of this message