>Hi All
>
>I have a few questions :
>I have never used SQl before but here goes
>I have to take and existing VFP 6.0 Application which uses vfp tables as a back end and transfer the backend to use SQL 6.5.
>
>My questions are :
>1) Do I use the upsizing wizard or not?
>2) If i use the upsizing wizard do i then delete the VFP database and tables?
>3) Does it mean using a SQL 6.5 backend that i have to re-write my code?
>
>Thanks in advance
>Fida
I'll try to answer these to the best of my knowledge.

1. The upsizing wizard would be the easiest way to do a conversion. It will create remote views for you and move the data to SQL Server.
2. You would want to remove the tables once you have upsized. You DO NOT want to remove the database because this contains all of the references to your remote views and connections.
3. No, you should not have to rewrite you code. You may want to in the future in order to optimize but for the most part upsizing should get you going with an minimum of problems.

HTH,
George