>I have an app written in FP 2.6a that the client wants to convert to SQL Server. Can anyone point me toward resources that can tell me what is involved in this? Are there automated tools?

Here are some articles on SQL Server and foxpro (mostly vfp)

http://www.levelextreme.com/cgi-bin/xworks.exe?2,1,3,239
http://www.vitus.com/vfpcs.html
http://msdn.microsoft.com/vfoxpro/technical/articles/clientserver.asp

Also check out the upsizing wizard in VFP.