>need code to create remote views from local views like upsize wizard.
>i don't want to use upsize wizard because sending datas from larges tables take a long time.
>i prefere using sqlserver dts to import datas.

You can "read" your current view definitions via DbGetProp(), ADbObjects() etc., see also gendbc.prg in Vfp's Home()+'tools\gendbc' folder.

And then modify them, insert "Remote Connect" clauses for example, either manually or even programmatically.
At that point, the backend syntax matters so that for example VFP functions like DateTime() or Iif() must be replaced with their equivalents in your particular backend syntax, say "To_Date()" and "Case When" in Oracle.


hth
-Stefan