>>Hi,
>>I have an old VFP procedure with a VFP DBC.
>>My need is to use an SQL Server db (with almost the same DBC tables and structure).
>>I've seen that in VFP 7.0 there is the Upsizing Wizard functionality.
>>My question is : how does VFP 7.0 access to SQL Server ?
>>still using ODBC or there are some new functionalities that let me bypass the ODBC, (and in this case : if I use the Upsizing Wizard to translate my DBC in an SQL Server db, what about my seek instructions ? have I to change my old program ?)
>>
>>Thanks
>>Michelangelo
>
>The upsizing wizard also exists in VFP6. It uses ODBC.

Craig;

I have used the upsizing wizard in VFP 6.0 once and only once - out of necessity and time restraints, to create a SQL Server 7.0 dbc and tables. It worked seamlessly and either I was lucky or it was designed to work with what I did.

My preference is to do this within SQL Server, but it is nice to know it worked!

Tom