>Dear Friends
>
>In our office we use VFP 6.0 database and applications develop in VFP 6.0
>
>Now we have to give our database to our client who wants it in SQL Server database.
>Please let me know how to convert VFP database to MS SQL 6 or 7
The VFP Upsizing Wizard will help port your data from existing native tables contained by a DBC into SQL Server tables accessed via remote views; in place of table and local view references you'll reference remote views to access the SQL Server based tables. It's likely that a considerable portion of your aplication will need to be rewritten if you've followed traditional record-oriented xBASe practices in your existing application. There are several books out on using VFP in the client-server environment; I'd take a look at the offerings from Hentzenwerke Publishing (
www.hentzenwerke.com) for some books which will help with the move.
Be aware that there is more involved with such a move than a couple of paragraphs of instructions - if you have not previously worked with SQL Server or VFP with a database backend, there is a sizable learning curve involved in moving to a client-server environment, and SQL Server does not use the identical syntax that VFP does.