Hi Mark,

I don't know if I made myself clear. I want to continue to run my app locally in VFP. I only want to copy a data and lookup tables up to our data warehouse to allow people with the proper access to use Crystal Reports to generate reports from the data.

I don't think I want to start sending only one record at a time. That doesn't sound good.

:o) Audie


>>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.