>Mark,
>
>Would you please give me some hints of what i should and should not do for my conversion? Did you run into any problems during developing your VFP app with Oracle? Is there anything for me to watch out? any inputs would be greatly appreciated.
>
>Thanks.
I have not really run into problems, at least no more so than developing a VFP-Only app. I have really had to dig in and learn about Oracle. Database design strategies are about the same as VFP. Of course Oracle is much more sophisticated, has more security, etc. Your knowledge of SQL will also be severely tested.
I use MS ODBC Driver for Oracle and NOT the drivers from Oracle.
As far as converting from a VFP DBC to Oracle, I did use the VFP Upsizing wizard to generate the SQL needed to create the tables, etc. However, I then went into the tables VFP generated and copied the SQL into SQL*Plus script files. I then ran these scripts from SQL*Plus. I used a combination of updatable remote views and the Oracle SQL Loader to insert the data into the tables.
Mark McCasland
Midlothian, TX USA