>What is the quickest and safest to completely transform a full VFP application to a SQL backend. Such as copying data and structure as well as converting local views to remote views. If there is any tool or special shortcuts your help would be greatly appreciated as doing this all manually would take four months. TIA

Hi Ken,
There is not a magic way to transform application which uses DBFs to SQLServer as data storage. You will be forced at least to rewrite dataaccess code changing VFP commands with T-SQL one.
When we worked with VFP6/7 we use our own data classes for simultaneous processing of both data storage, but all VFP code was T-SQL compatible.
My personal advice is to move to VFP9.0 and to use CursorAdapter. There is a lot of staff for it including CA builders. If you like I could also send you Venelina’s session notes from last 2 German DevCons about using of CA.