>We are using a software program by Icode called Everest. We are moving from a Foxpro compatible Advantage Database Server to SQL. I have written 60 basic foxpro programs and want to be able to quickly and easily convert them for use with the SQL data. I don't know anything about objects and fancy stuff as my Forxpro experience and code writing still looks a lot like it did in the DOS days. Luckily most of the tables have the same names, indexes and schema.
>- How do I access the SQL data? Do I have to create views for every table?
>- How can I use the indexes in the SQL database to order my data?
>- Are there any 3rd party products which will allow me to manipulate the SQL data as if it was a local Foxpro DBF?
>- Is there any place I can go to read about this subject?
>
>Thank you for your patience and assistance.

New VFP8.o has cursor adapter class, which work in same way with DBS and SQLServer
You can read next article http://portal.dfpug.de/dFPUG/Dokumente/Konferenzen/VFP-Konferenz%202003/E-CAD.pdf
You can use our freeware DataTools(download #12963) to transform your FP database in SQLServer one.
If you need any other help feel free to contact us