Guys,

I have to produce a feasibilty study of modifying our current VFP system to use an Oracle database (at the flick of a switch) instead of its current FoxPro 2.6 set up of free tables.

Does anyone have any thoughts/comments/experiance as to which is better SQL passthrough or Remote Views.

Please also consider the following:

1. The application also has to point at different Oracle boxes depending on its current status (development, UAT, production, DR, etc.)

2. There are some 60+ tables currently used by the system

3. These tables exist in both Oracle & FoxPro

4. We need to implement this with the least impact on the current system (code).


Thanks in advance for your input,


James.

P.S. If I was to use the remote view approach; is there anyway I can use indexes set up in Oracle instead of having to reindex each one of my views every time they're opened?