Re: Fox pro 2 Oracle

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
Received on Mon Mar 05 2001 - 23:16:22 CST