Hi Gaylen,
>At this point I am using only Foxpro tables.
Call it semantics, but you have NOT developed a client/server application. You've developed a file server application. A client/server application does the vast magority of the processing on the server and returns to the client just the information requested. The VFP data engine resides on each client and therefor the processing occurs on the client and not the server.
It's a common misconception among VFP developers to think that because the DBFs are on a network server somewhere that the application is a client/server app.
>I have written the applicaton such that the conversion to Sql Server should be rather painless. I really don't see the volume getting to the point where we need to switch although the business is growing very rapidly.
How are you accessing the data? Are you binding your forms to business objects that are in turn responsible for connecting and updating the data?
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development