>Hi All,
>
>I would like to upload a copy of my database to our data warehouse (Oracle) so that the data can be used to run reports from Crystal Reports. The application would still be run on a local PC, but needs to periodically upload the database files to the data warehouse to keep the data accurate.
>
>I need to have some ideas on how this can be accomplished. Has anyone used the Oracle Upsizing Wizard in VFP 5.0? Would this help me to copy the files up to Oracle? If so, can the wizard be run programatically?
>
>Thanks in advance!
>
>:o) Audie

Whew, where to start...

If you have a large amount of data, you may be better served to copy the data to a comma-delimited files and use Oracle's SQL*Loader assuming the exact table structure is already created in Oracle.

Use MyTable1
copy to mytable1.txt delimited

You will need some admin rights on the Oracle server to do this.

Or you can use SQL passthrough [see SQLExec() function in VFP] to send data 1 record at a time.

Once you have all the data in Oracle, I would create or modify a VFP app to use updatable remote views of the Oracle data. Then you do not have to do periodic uploads.

I have had the luxury of starting my tables, data and new apps with Oracle available, so I have not had to use the wizard.