Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP vs. SQL Server
Message
From
26/06/2001 15:51:47
 
 
To
26/06/2001 14:10:11
Rene Van Den Berg
Infertility Database Systems Ltd
Islington, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00523306
Message ID:
00523811
Views:
8
>Thanks all. Problem is I suppose that we have around 50 clients using our software quite happily as it is in VFP. It's not a product-to-be-written, but a pretty complicated application that is in its 6th year of development.
>
>I think the suggestions are pretty sensible. We just have to find the time to do it.
>
>Thanks again.
>
>Rene.

If you do not already have an N-Tier design then you are talking probably a major rewrite. OTOH if you are already using local views instead of accessing your DBFs directly, then it might not be too difficult to change to a client-server (2-Tier) design where you basically switch DBCs to use one with remote views with the same view names, and you are C/S and can talk to other back-ends.

Do an analysis of your current data access scheme to see how much work will be required. Consider that not all tables need/will be upsized to SQL/Server o similar as you may want to keep them locally in DBFs.

HTH


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Reply
Map
View

Click here to load this message in the networking platform