>>We are planning to rewrite a VFP application which uses DBFs to .NET and SQL Server. The system is extremely large and is comprised of a large number of subsystems invoked from a main PRG and menu. It is not considered feasible to convert everything at once. Instead the plan is to rewrite a piece at a time as resources and budget become available. Has anyone done something like this? To me it seems like the data is going to have to reside in both VFP and SQL Server until everything is converted. Any tips on good ways to do that?
>>
>>Thanks in advance.
>
>Something else to throw into the mix (if someone else hasn't already done it)... Advantage Database Server allows you to access a DBF from both the database server and VFP. So if you have two modules that access the same table and are migrating one module at a time, you can do it. It is the only database server that can do this, while still providing the same basic database services as SQL Server, and it has a .NET provider. Once all code has been rewritten in .NET, you could then move the entire database to SQL Server if you want.
>
>I don't use Advantage, but that's what I hear. I think both Doug Hennig and Ken Levy have written/talked about it.

I had not heard of Advantage but will definitely look into it. Thanks.