>I have over five years of FPD/W 2.x, but am still very new to VFP 5.0.
>I have a small add/edit/save app for creating requisitions prior to it becomeing a purchase order. It is starting to run pretty decent now, thanks to the advice of many on this forum. Now, the client just told me they want me to have all the data reside on SQL Server. Yikes, I'm just now over the hump of getting the feel of the form designer and updating files, etc.--but I had hoped not to have to deal with this so soon. By the way I only have one .dbc with three tables in it. During my reading/studying on VFP I have glazed over the SQL/remote access parts, but have noticed on consistent them: everybody says to do something different. I need some real advice on the best way to do this, because it will be how I do everything in the future: Do I use the upsizing wizard? Do I use remote views ??? DO I use SQL pass through ??? SQL Exec all my commands ??? How can I make distribution disks for users without VFP on their machine to run my app and attach to SQL Server ??? What happens to my
>memo fields in VFP when they are on SQL Server ??? Should I work in temp files on the local and then send changes to the SQL Server ??? I am so in the dark about this, because of all the strong opinions regarding each of the options. I can't afford to screw this one up !!!!
>
>Many thanks in advance for your time and advice !!!!!!

So many questions at once. I think it would be more reasonable to start separate threads. Here are just few things:
1. Don't worry about VFP distribution, just prompt your users (or do it yourself) to create appropriate ODBC source.
2. IMHO, remote view is the most logical way to move data to SQL-Server. At least you will get a lot of hand-on experience moving this way.
3. Normally, your app will use both remote views and SQL pass-through.
4. Try to eliminate Memo fields. SQL server treats them differently than VFP, and you can get in troubles (though resolvable) here.
5. And don't expect that your app will work faster on SQL-Server :)