How to convert data from paradox to oracle
without using sqlloader ?
Is there any tool which converts?
Can Migration work bench convert from paradox to oracle?
This process should be regular i.e. Twice a week..
Is there any ETL tools are available like oracle datawarehouse builder which will convert this data?

02-04-2002, 10:11 AM

marist89

Can you use ODBC with Paradox? If so, create a paradox database, attach via ODBC your oracle tables, and do the operations from paradox.

02-04-2002, 10:17 AM

atul

how to convert data from paradox to oracle

Yes , we can connect paradox through odbc ..

but from that i will connect to paradox ..
how i can convert that data into oracle tables ?
Can you please explain ?

02-04-2002, 10:22 AM

marist89

It's been a while since I used paradox, but the gist of it would be something like:
1. create tables on oracle database
2. attach the tables to your paradox database
3. perform an insert/append query from your paradox table to your attached oracle table

02-04-2002, 10:46 AM

atul

how to attach the tables to your paradox database
from oracle database?