Speed is not a reason to move from VFP to SQL Server. I have seen VFP applications that are faster than SQL Server and vice-versa. Much of it depends on the design and coding skills of the developers.
However, you can produce a functionally equivalent application with .Net and SQL Express.
>I actually meant , when we distribute off the shelf application we may print out on CD cover minimal requirements either for stand alone installation or server installation. Given these minimal requirements are met, may we be sure that performance will be acceptable. As for queries, it will be full text retrieval with third party API , so no joins , no complex SQL , predominantly
>
>ID in ( 1 ,3 ,5 , 7 ... ) or
>
>indexed_field like 'value%'
>
>For above mentioned prerequisites can we create a generic application assuming no IT folk will be required at client end at least for stand alone installations.
>
>What I am trying to say it seems to be possible to me to create Winforms + SQL Server Express 2005 application which could be superior to existing legacy Visual Foxpro ( or at least to match ) ) in all aspects of user experience , but surely I have doubts.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer