Comments inline..
>The one question I had though was about Views and indexes. My app opens tables and sets indexes. Can I just replace all my references to tables (USE MyTable) with Views (USE MyView) ?
Yes. That's the general theory behind Remote Views. They emulate tables by encapsulating SQL Passthrough (SPT) calls.
>
>If so, how do I allow my app to set indexes on Views ? (SET ORDER TO TAG..)
>
You don't have to. SQL Server's optimizer will choose the correct index (if any) to solve the query.
>Or is this the totally wrong way to do it ?
Jim brings up a very good point. Most people migrate to SQL Server for capacity, security, and robustness. Speed is very rarely a reason. And as far as data availability to other application, you should be able to get to VFP data using the ODBC driver in the way that you would get to SQL Server data using the ODBC driver.
-Mike