General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Oracle and all that
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only