Re: migrate paradox on msoft to 8i/9i on sun

Hi,

Have a look at Oracle Migration WorkBench. I'm not sure, but may be it can migrate Paradox database using ODBC.

To export Paradox database to text files, create Oracle DDL scripts and control files for SQL Loader you can use command prompt migration tool Chyfo at http://www.ispirer.com/products

Best regards, Dmitry

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:3C3CB13F.E052C62_at_exesolutions.com...
> Save off the content of the tables in some delimited format. I would
suggest
> something other than comma separated values if you have any commas in your
> data ... try vertical bars as a substitute. Then load into Oracle using
> SQL*Loader.
>
> You will want to build the tables, indexes, and constraints from scratch
to
> take advantage of things Oracle has that Pdox doesn't/didn't. But if you
> want a tool to get you started ... you can reverse engineer Pdox to Oracle
> with ERWin.
>
> Daniel Morgan
>
>
>
> chrisp wrote:
>
> > I want to migrate a paradox db on msoft to oracle 8i/9i on sun. Is
there
> > a tool/utility/methodology
> > to do this? I'd like it to be a one step process if possible.
> >
> > If not is there another way say to migrate paradox to access then to
> > oracle? A whitepaper or
> > doc on this would appreciated.
> >
> > TIA
> >
> > Chris
>
Received on Thu Jan 10 2002 - 12:20:34 CET