Looking for feedback from developers who have implemented systems using Foxpro's data storage (Foxpro DBCs and/or tables), and an SQL database such as SQL Server or SQLAnywhere.

I'm re-developing an older DOS-based Foxpro system. The app will have approx. 50-80 tables, with some of the tables containing 1-3 million records.

The system will run on Netware, NT, Win2000 Server or stand-alone machines.

My concern is susceptibility to data corruption whetther it be from a user turning off a workstation, or stand-alone PC, or if power is lost at the server and it's not properly shutdown, etc.

Is either platform more "sensitive" than the other to data corruption, etc.?

Any feedback as to this specific issue or other issues as to performance, whatever.. would be appreciated.

If you have a recommendation, base it on the fact that I have no experience with SQL databases - all my apps over the years, DOS or VFP, have used Fox tables.

Thanks,
Bill