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? And goes without saying - you want to have a good technical architecture design for the different layers. I probably sound more like a project manager (oh, wait, I am one now!), but these things are important.
You'll probably get dozens of good suggestions from others...here's one that can be vital if your application has any particuarly tricky parts, and that's to build prototypes.