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: Migration tool - Data Integrator or Migration Workbench

Re: Migration tool - Data Integrator or Migration Workbench

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Wed, 31 Oct 2007 11:04:16 -0500
Message-ID: <74f79c6b0710310904q9a8637bp4d970f99a4e881d0@mail.gmail.com>


I'ev used OMWB to help migrate MySQL databases. I didn't use it end-to-end though. I used it to generate some shell scripts and sqlloader files, but from there I did it manually, or should I say I wrote my own shell scripts to automate it.
In a later migration I ended up just writing my own PL/SQL to generate these files, since sometimes it's a real pain to OMWB to work.

Finn

On 10/31/07, kathy duret <katpopins21_at_yahoo.com> wrote:
>
> Anyone have any experience to share for either tool?
>
> We actually own Data Integrator but the person who used it has moved on.
>
> Doing a 12i Apps implementation and moving data from:
>
> Sql Server, Access, Excel, MySql, Postgress and yes one small Dbase
> database.
>
> Most can handle Sql Server, Excel.
>
> I saw Migration Workbench can do MySql and I believe Access
> But what about Postgress (never have worked with it) and Dbase (20 years
> ago)
>
> So any thoughts to share?...
>
> Happy Halloween!
>
> Kathy
> Offical Candy Taster - chocolate is my specialty
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 31 2007 - 11:04:16 CDT

Original text of this message

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