>I was wondering if anybody ever created a project with database split between VFP and SQL Server? How practical it was? Any problems?
>
>I want to start converting a very large application from VFP 6 VFP DB to VFP 9 and SQL Server. But I realize the magnitude of the project will be too big to accomplish in reasonable time. So I am thinking about an approach of moving only one table to SQL Server. This is a very big table (of about 300,000 records) that often gives me problems (corruptions). Then, I could move other tables of the application to SQL Server, one step at a time.
>
>Any suggestions or warning will be greatly appreciated.
>
That is possible. Even when we use SQL Server, we continue to use DBFs for local metadata. Of course, you'll have to make the necessary changes for a client/server environment, but that's the subject of an entire book (
http://www.hentzenwerke.com/catalog/csvfp.htm). As a side note, VFP 9 offers better detection of corruption than VFP 6, but you will still need a tool (Stonefield, FoxFix, Recover, etc.) to repair it.