Re: Fox pro 2 Oracle

Yes, that's the way we do it as well.

On Tue, 6 Mar 2001 13:16:22 +0800, E_at_E.COM (steve) wrote:

>Hi,
>I tried oracles converter program for fox 2.6 but it was too messy.
>Iv'e taken >100 tables from fox to oracle,
>using a simple foxpro program that loops through the data.
>
>open the foxpro table to transfer
>scatter the data to variables
>build an sqlexec statment,
>
>
>
>Jim Davis <jimdavis_at_iprolink.ch> wrote:
>
>> It is pretty easy. But the key is of course setting things up correctly in
>> the first place to handle the correct formats for datetimes and PKs. If the
>> data is not good enough to APPEND directly, then some pre-APPEND massage
>> could be required.
>>
>> As far as the "what then" is concerned if VFP runs into an error and stops
>> appending, if table buffering is set on the view, then you can rollback, fix
>> the problem, and try again.
>>
>> Of course you can always loop thru your source data and construct SQL
>> statements for each row, SQLEXEC() them thru an ODBC handle, and catch any
>> errors at the row level (and even wrap your loop in a transaction so you can
>> still rollback if any errors are not recoverable).
>>
>> Jim Davis
>> Informatique Ressources Humaines
>>
>>
>> "Ted Knijff" <knijff_at_bigfoot.com> wrote in message
>> news:3aa25f09.24797847_at_news.online.de...
>> > Well, that sure sounds easy, but I don't know about stuff like
>> > primary keys (where Oracle is a bit more stringent than VFP) and
>> > date formats and datetime formats and memo fields and logical fields
>> > and code pages...
>> >
>> > Because as soon as APPEND runs into an Oracle error, it just sort
>> > of stops appending. What then ?
>> >
>> > On Sun, 4 Mar 2001 10:16:18 +0100, "Jim Davis" <jimdavis_at_iprolink.ch>
>> > wrote:
>> >
>> > >Create a VFP view (if this is VFP) for the Oracle data, in the same
 format
>> > >as the data you want to import. Make sure to turn on the appropriate
 update
>> > >options in the view. Open that view, and APPEND into it.
>> > >
>> > >Jim Davis
>> > >Informatique Ressources Humaines
>> > >
>> > >
>> > >
>> > >"Tristan" <moonshine_at_apex.net.au> wrote in message
>> > >news:983444934.868085_at_draal.apex.net.au...
>> > >> Is there a simple way to copy in foxpro data into oracle tables? At the
>> > >> moment I am copying out the foxpro data to a simple file, then using
 the
>> > >> sqlldr utility.
>> > >>
>> > >> Thanks,
>> > >>
>> > >> Tristan
>> > >>
>> > >>
>> > >
>> > >
>> >
>> > EMail: knijff_at_bigfoot.com

EMail: knijff_at_bigfoot.com Received on Tue Mar 06 2001 - 01:40:54 CST