Re: Migration to Oracle

Depends of the DB you are migrating from.

  Best case: it is a standard informix/sybase/db2, there might be migration workbenches available.

  Next best: Older DB or ODBC, you might be able to find a transparent gateway which would make it as easy as Create <Newtable> as select * from oldsystemtable_thru_gateway;

  Worst case: get flatfiles exports of all the tables in the old system, then write some .ctl files to make sqlloader pull them in.

Find out for certain that it is a UNIX system, you don't want to screw with old HP3000 or PDP-11 h/w s/w combo, which may have "nightmare" project overtones. In any event, looks like some job security,

R

"Brian Vienneau" <b.vienneau_at_sympatico.ca> wrote in message news:3vRO6.1280$Lc7.154511_at_news20.bellglobal.com...
> Greetings:
>
> I need to know of any methods preferably the best method to migrate
 another
> database to Oracle. This is important because a company will hire me if I
> can do it. They have not stated what the other database vendor is yet but
 it
> is old and runs on UNIX I'm assuming. I can build the Oracle DB myself but
 I
> just need to know of methods for transferring the data.
>
> Thank you very much,
>
> Brian Vienneau
>
>
Received on Wed May 23 2001 - 23:12:47 CEST