Hi Alan,

In order to do development with Sql Server you can use MSDE 2000 that comes with VFP7. The only problem with it that it doesn't include any GUI tools to manage it. Thre's a free MSDE 2000 management tool at http://www.webattack.com/get/dbamgr2.shtml (I didn't work with it).
VFP includes upsizing wizard. I'm not sure why do you need to upsize anything if you're planning to do development for SQl Server backend.

>Sergey, thanks for the reply.
>
>>>Take a look at Creating Client/Server Solutions in VFP help.<<
>
>I have read the chapter you suggested, but there are still a few issues that are still unclear to me.
>
>I don't have SQL Server (the company I am developing the VFP front-end for will), but would like to test accessing SQL tables via. remote views or SQL pass-through. Do I need the full SQL-server in order to do this, or does the ODBC driver take care of this?
>
>I would like to get hold of some simple SQL-server tables to practice setting-up remote views. Will I have to install the MSDE that comes with VFP, or is there an easier way? Alternatively, what is the easiest way to convert VFP tables to SQL format? From what I have read, the SQL upsizing wizard does a lot more than this and expects SQL-server to be installed also. For instance, I can only see how to upsize from a database, not an individual table.
>
>TIA,
>Alan