First, development with VFP is quite easy. You can get Personal Oracle [which I beleive is now free from Oracle] which installs on your own PC for development work. When you are ready for production, all you do is export your database from PO and import it into the production Oracle.

Alternatively, all my Oracle development is done with SQL*Plus script files. These scripts are analogous to DOS batch files. They can be executed in SQL*Plus to create tables, views, indexes, sequences, SPs, synonyms, roles, etc. This is like having the PRG file generated by the VFP GENDBC app to recreate your VFP database. When I need to make a change, I first make the change in the script file then I either rerun the script or manually make the change using a SQL*Plus command.

I also have an ODBC DSN Class in the Files section and and Oracle/VFP article in the Articles section.

I also suggest you do a search on my member # and the keyword Oracle over the last few search periods. You will find suggested books, URLs, and other useful threads on this topic.

>Looking for opinions...We are looking at designing a new in-house application that upper management wants to ultimately reside in an Oracle database. Number of users initially will not be great (40-50). We are trying to rationally determine what type of front-end to utilize. Personally, being a old FoxPro developer (from FoxBase on) I recommend VFP. Other products mentioned have been Power Builder and Oracle for forms. Does anyone have any personal recommendations.
>
>My initial gut reaction was to start out with just VFP and eventually upsize the code to an Oracle backend. Does anybody have anythoughts or experience with this situation and what pros and cons that you experienced.
>
>Understand that this a VFP thread and opinions might be biased but I really am looking for some type of real life recommendations from people who have been through this before so that Upper Management can make an informed decision.
>
>Thanks,
>
>Wayne Frenck