since 2 months i'm trying and thinking about the easiest way to have sqlserver as backend of vfp apps. i firstly tried to use SPT. but this way need to much code :
1-remove all tables and views from the DE.
2-create procedures that requery and update.
3-convert vfp commands to sqlserver and so on
i have not found a ready made procedure that performs all i need to migrate to sqlserver.

and at last i decided to simply use the upsize tool. but the upsize has some problems :
1-it doesn't convert vfp fonctions to sqlserver such as alltrim(), ctod(),val(), iif(),group by and having rules.

vfp developers, help us with ready made procedures that do all these problems we meet.

i don't want to recode my program.