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

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Wed, 09 Jan 2002 21:08:15 +0000
Message-ID: <3C3CB13F.E052C62@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 Wed Jan 09 2002 - 15:08:15 CST