I am also working on moving a VFP database to Oracle. I am using the new VFP8 CursorAdapter to get my data from VFP into Oracle. My connection is to Oracle with a SelectCmd = [SELECT * FROM MyTable]. When I call the CursorFill method, I do so with the no data option. I also set the buffering to table. I now have a cursor connected to the Oracle table. I can then APPEND FROM the VFP table. Finally, I issue the TABLEUPDATE() command. The only caveat is the cursor created by the adapter has to result in the same data types as those in the VFP table. Otherwise, you have to handle structural differences yourself. e.g., VFP Logical to Oracle NUMBER(1).

If this is too much trouble, SPT will be the fastest. Scan each table, and create your own SQL-INSERT for each table.


>I am currently in the process of upsizing our FoxPro 7.0 database to Oracle 9
>
>I start by creating the table in oracle
>making a remote view of it
>and then I use
>SELECT * FROM table INTO ARRAY array
>and
>INSERT INTO table FROM ARRAY array
>
>Is there a faster way
>
>Some of my tables have reached the limit of 2 Gigs.
>Probably wont be able to use arrays for those...
>
>Thank you for your help
>
>Cicilia