Hi Whitney,

Since no one has said anything about your objectives, Ijust thought that it might be useful to point out that "speed" is most likely to *decrease* using SQL Server over VFP, though at 10,000 records or less the differences may not be dramatic. But, in general, SQL Server is **NOT** considered to be faster than VFP (when the VFP app is correctly using "Rushmore".

As for providing data for other applications, there may be other ways to accomplish this, one of them being periodically 'exporting' your data to SQL Server.

Good luck,

Jim N


>Thanks, that helps!
>
>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) ?
>
>If so, how do I allow my app to set indexes on Views ? (SET ORDER TO TAG..)
>
>Or is this the totally wrong way to do it ?
>
>I probably should have originally designed the app with views, but at that point SQL Server was something I had no designs on tackling.