Re: conversion

From: hi <1_at_23.com>
Date: 2000/05/15
Message-ID: <RSYT4.2418$pM6.2249599@news2.mia>#1/1

I have a solution. I am in the middle of do this. I created 2 clipper programs.

first program that dumps the structure to an ascii file, and the other that dumps the data to an ascii file(ie address.txt).

take the ascii structure file and wrap 'create table address' command around it (execute sql script)

create a 'ctl' file with the same ascii structure file.

sample 'address.ctl' file

LOAD DATA
INFILE *
APPEND INTO TABLE address
fields terminated by "," optionally enclosed by '"' TRAILING NULLCOLS

(        name,
         addr1 ,
         addr2 ,
         birthday               DATE "YYYYMMDD",
         ssn

)
<end of address.ctl' file>

now run sqlLoader:

sqlldr userid=username/password control=address.ctl log=addressrslt.log data=address.txt

'addressrslt.log' - log file of the results 'address.txt' - ascii input file from DBF

maybe this will help

Paul Kolbohm <paul.kolbohm_at_mallon.demon.co.uk> wrote in message news:957887834.21133.0.nnrp-14.9e98496d_at_news.demon.co.uk...
> Please help and I will be forever grateful.
>
> I have a FoxPro 3.0 clipper database and I wish to convert the tables and
> the data to an Oracle 8.0.5 database does Oracle allow conversion from
> FoxPro?
>
> If yes does anyone how.
>
> I can convert from FoxPro to Access then to Oracle 8.0.5 but I want to
> convert direct to Oracle from FoxPro/
>
> Paul K.
>
>
>
>
>
>
Received on Mon May 15 2000 - 00:00:00 CDT