Re: Migration to Oracle

Can you explain what you mean by a migration workbench and how this would work? I am assuming this is software?

Thanks,

Brian Vienneau

"Richard in" <richardintx_at_yahoo.com> wrote in message news:jJVO6.26183$bv2.7769860_at_typhoon.austin.rr.com...
> 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 Thu May 24 2001 - 12:48:10 CEST