Hi Garrett,

Each division office is running their own set of VFP data. The data warehouse needs to hold a files with the combined data from all the division offices. Further, most of the division offices do not have direct WAN access, it is achieved through a modem connection to Compuserve.

What I envision doing is when a VFP user clicks a "send to warehouse" button, I will open a a mirror database with the exact same files and structures as my VFP database and then append records for these files from the VFP database. I then want to programatically run the "Oracle Upsizing Wizard" in VFP on this mirror database to upload these files to a tablespace designated for that office in Oracle. When oracle receives the data for that office, it can open the main files and delete all files in that table for that particular office and then append the new data back in.

The data warehouse is just a mirror of all the division data tables. The reason for copying my VFP files to a mirror database is that the "Oracle Upsizing Wizard" takes liberties to change stuff like file names in the DBC, which I will only allow on a copy of the DBC, not the original.

What I need help with is - How do I programatically fire off the wizard and give it the arguments needed to accomplish the task and not show the wizard to the user.


:o) Audie


>>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.
>
>Dumb question, Audie: why not let them run the CRs directly from the VFP data?