I never use the upsizing wizard to upload the data to Oracle. One way to do this is to create the Oracle tables, then create remote views to each Oracle table. Then issue CURSORSETPROP('Buffering', 5, 0) at the command window. When you open each view, open them with the NODATA clause. They will also be opened in with optimistic table buffering. You can then APPEND FROM or INSERT INTO or do whatever to get the data into the view. When all the records are there and the data is correct, issue a TABLEUPDATE(1, .t., 'view_name') on the view. Now be patient as VFP sends the records to Oracle. Close the view and repeat for the next view.
I open the view as table buffered so each record is not automatically sent to Oracle when a new record is appended or when you move the record pointer.
>Hi,
>
>I hope it's ok to ask this questions in here.
>
>Does anyone know of a good migration tool that I can use to convert Visual Foxpro tables to Oracle 8i? I've tried using the Wizard that came with Visual Foxpro 5.0, however I received an error during the conversion. The table structures got created, but the data didn't get inserted.
>
>If you could suggest a migration tool that would do this or even suggest a solution to the problem that I had with the Foxpro wizard... I would really appreciate it.
>
>Much thanks in advance...
>
>Jolene
Mark McCasland
Midlothian, TX USA