>>>I need to migrate to VFP9 first (yes I know not 100% necessary but desirable)
>>>
>>>Then I need to move to SQL server
>>>
>>>Then I need to move to .Net
>>
>>You don't need to go to vfp9 to use sql server. We have it here in both 6.0 and 7.0. Do you have to move to 9?
>
>John
>
>Now that's really helpful - no I don't need to move to VFP9
>
>Sadly all my table work in VFP6 is individual calls which means a hell of a lot of changes - any tips on putting SQL in as backend?
>
>Thanks
>
>Colin

You can change the local sql operations on vfp tables to access the analogous sql tables by setting up a connection string, creating your connection then issuing sql passthrough and getting the return set into a cursor for use in vfp. Not sure its going to be terribly difficult but will involve some changes ....