>I would like to know people's experience in switching their native VFP apps to VFP client server.
>Was the data read/write speed faster afterwards? Where there other performance issues? (Please specify typical reccount()'s)
It depends on data amount, but for larger tables SQL Server is much better solution. I have a vision on a part of our warehouse application: we have two related tables the main one with about 900-1000 records per day and the child table has 5-8 records for each record in main table. Upsizing this to SQL Server speeded the execution more than twice. (Of course it is very important to have appropriate indexes.

>Is one server necessarily better than another (Oracle versus Microsoft)?
If you will use to store business information both servers have similar productivity and performance, but MS SQLServer is much cheaper. Another plus is stable integrated system - WinOS-SQLServer-VFP.
If you will make system which will store and retrieve images Oracle is better yet.

>Did the app require major re-writing?
Yes, if you had working directly with tables and has them in Data Environment. If your application is written as client-server using remote connections the changes will be minor.

>Were there unforseen pitfalls during the conversion?
If your application needs to be rewritten sometimes it is difficult to foresee how the business rules will be transformed. The data processing algorhythms must be described very detailed to avoid missing calculations.
>No need to limit comments to my questions above. Thank you in advance.
>
>Derek