423,103 Members | 1,428 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,103 IT Pros & Developers. It's quick & easy.

converting DB2 triggers to Oracle

P: n/a
I need to convert a bunch of DB2 triggers to Oracle. Is there any
kind of tools for this?
Jun 27 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
--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:

A. 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/tec...nch/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.
[...]
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.
</q>
http://www.swissql.com/products/db2-...to-oracle.html
Note: they also offer similar capabilities for the reverse migration:
http://www.swissql.com/products/orac...le-to-db2.html

C. 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/Interne.../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
Jun 27 '08 #2

P: n/a
"The Boss" <us****@No.Spam.Please.invalidwrote in message
news:48***********************@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:

A. 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/tec...nch/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.
[...]
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.
</q>
http://www.swissql.com/products/db2-...to-oracle.html
Note: they also offer similar capabilities for the reverse migration:
http://www.swissql.com/products/orac...le-to-db2.html

C. 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/Interne.../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
I tried some of these tools (SQLWays and SwissSQL) about 2 years ago, and
they did not generate working triggers and SP's, although they did a good
job of moving data from one database to another.

I recently tried SQL Ways just a month ago on some simple triggers
converting from DB2 to Oracle, and still there were some mistakes, but
fairly easy to correct if you know any Oracle. Not sure how well it works on
complex triggers.

SQLWays basically advertises a lot of stuff that doesn't actually work, but
the upside is that it is basically a one-man company and you can call the
developer (owner), and if you explain what is wrong he will try to fix it
quite quickly.
Jun 27 '08 #3

P: n/a
Mark A wrote:
"The Boss" <us****@No.Spam.Please.invalidwrote in message
news:48***********************@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:

A. 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/tec...nch/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.
[...]
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.
</q>
http://www.swissql.com/products/db2-...to-oracle.html
Note: they also offer similar capabilities for the reverse migration:
http://www.swissql.com/products/orac...le-to-db2.html

C. 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/Interne.../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

I tried some of these tools (SQLWays and SwissSQL) about 2 years ago, and
they did not generate working triggers and SP's, although they did a good
job of moving data from one database to another.

I recently tried SQL Ways just a month ago on some simple triggers
converting from DB2 to Oracle, and still there were some mistakes, but
fairly easy to correct if you know any Oracle. Not sure how well it works on
complex triggers.

SQLWays basically advertises a lot of stuff that doesn't actually work, but
the upside is that it is basically a one-man company and you can call the
developer (owner), and if you explain what is wrong he will try to fix it
quite quickly.
I agree. These migration tools will generally create syntactically
correct objects. But they will be poorly coded in all cases other
than the most simplistic.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
da******@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Jun 27 '08 #4

P: n/a
"DA Morgan" <da******@psoug.orgwrote in message
news:12***************@bubbleator.drizzle.com...
I agree. These migration tools will generally create syntactically
correct objects. But they will be poorly coded in all cases other
than the most simplistic.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
Actually, most of the time the syntax was incorrect or incomplete and would
not create when run on Oracle. Sometimes the problems were minor, sometimes
major.
Jun 27 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.