>Howdy,
>
>I am about to start converting a large VFP5 system from native Fox Tables to Client Server data (SQL Server).
>I was wondering if there is any FAQ / Tips & Tricks document around realted to this.
>
>Basically I'm looking for some info on what to look out for, what does not work, and what commands,etc. are good/bad.
>
>Any help would be appreciated.
>
>TIA
>
>John
>Please send any e-mail to:
>JFiduccia@connectrix-systems.com
>
>Thanks again

Aside from data migration, There are lot's of gotcha's in this conversion. Killer VFP SQL syntax will live up to it's name and kill you. Your DBC's that have any code for VFP will not upgrade, and waiting for large data returns will be different.

If you use an IIF() in your select statments, then you will have to go to a case statement.

Are you working under a purchased framework or your own home grown? Codebooks concept of Xv_your_view_name was great. Where the X can reference local or remote views, and be switched on the fly.

Mere Mortals does a great job for the devloper in getting individual data sessions switched one at a time.

Other SQL things are run away quieries, proper amount of temp space on the server as well as log space.