Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB2 to Oracle migration

Re: DB2 to Oracle migration

From: Birkir Bjornsson <birkir_at_teymi.is>
Date: Wed, 10 Mar 2004 23:48:35 +0000
Message-ID: <404FA953.6070207@teymi.is>


Hi Justin
Thanks for your response. Well Im migrating the database only once. The thing is that I have to extract the data from DB2 to an already made schema in Oracle.
So could I use Oracle Migration Workbench, or should I just make an ASCI file with the data from DB2 and use SQLLoader to insert it to Oracle. What would you
say is the easiest way? Or do you have some other hint for me?

Thanks in advance

Kind Regards
-Bippi

Justin Cave (DDBC) wrote:

>Is the question about a one-time migration, i.e. moving an application that is currently accessing DB2 to access Oracle, in which case the Oracle Migration Workbench is probably a good first step? Or is the question about regularly migrating data from DB2 to Oracle, i.e. replication, in which case Heterogeneous Connectivity would be a good approach?
>
>If the question is the former-- a complete move from one database to another-- be aware that you will probably have to invest a significant amount of time after the Migration Workbench moves the code to Oracle to get equivalent performance from Oracle. In general, applications are going to do things that work really well in one database but that aren't appropriate in another database. Migration Workbench will do a relatively dumb conversion of the code, which is fine for 60% of the cases, but you'll have to manually fix up the other 40%.
>
>Justin Cave
>Distributed Database Consulting, Inc.
>http://www.ddbcinc.com/askDDBC
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Birkir Bjornsson
>Sent: Wednesday, March 10, 2004 7:40 AM
>To: oracle-l_at_freelists.org
>Subject: DB2 to Oracle migration
>
>Hi
>
>I have to migrate a DB2 database to Oracle and was wondering if any of
>you have ever done it and have some hints
>for me.
>
>
>Thanks in advance
>Bippi
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Mar 10 2004 - 17:47:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US