>We are currently in a lull with our development cycle, so I have been given the task of comparing VFP to SQL. We have about 40 tables that get regular use and then another 150 tables for whatever. Our main tables have about 1,000,000 records in them and about 500mb in size. Some in the IS dept. have said that we could triple our data and still be alright. Others think we should upgrade to something like SQL or Oracle. I have been trying to find some stats or performance info to justify staying with FoxPro or to move to a differnet backend. Does anyone know of someplace I can look for the data. If we need to migrate our data, I would rather do it while we have the time instead of when it breaks down. TIA.
IMO, speed is not a reason to move to SQL Server. Table size, security, decreased network traffic, and remote users are good reasons. I've managed DBFs with 11,000,000 records (1.7 Gig) just fine.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer