Check out these articles from Microsoft. They have lots of good info. especially the one titled 'Integrating SQL Server with Visual FoxPro'.
http://msdn.microsoft.com/vfoxpro/technical/articles/clientserver.asp

>Howdy,
>
>I am about to start converting a large VFP5 system from native Fox Tables to Client Server data (SQL Server).
>I was wondering if there is any FAQ / Tips & Tricks document around realted to this.
>
>Basically I'm looking for some info on what to look out for, what does not work, and what commands,etc. are good/bad.
>
>Any help would be appreciated.
>
>TIA
>
>John
>Please send any e-mail to:
>JFiduccia@connectrix-systems.com
>
>Thanks again