Re: VFP and SQL SERVER

Author: Dan Covill

Posted: 2001-05-29 at 09:10:36

Jean:

Been there, done that. <g>

Sounds like 6 months minimum to get the current situation under control.

You say there's no program documentation; that probably means there's no=20

structural documentation either. So you have to build a whole system=20

documentation package as a by-product of making the system maintainable.

Obviously, there are too many tables and way too many "projects", you can't=

=20

collapse them until you figure out what they're doing.

I think C/S is a different project, and will take at least a year (and 2-3=

=20

persons) after you have the current system sorted out.

The alternative is to "walk away from" the current system and start=20

immediately on a new Client/Server system from scratch. This will take=20

even longer - trust me! (Re-inventing wheels, re-creating problems=20

previously solved somewhere in the existing code, etc.)

Dan Covill

Middleton Consulting, San Diego

At 12:28 05/29/01 +0200, J. Maurice wrote:

>Note : this mail is a sort of demo about Profox I am giving to one of my

>customer (GEAC is supposed to be an american company). But I need the=

answer

>!!

>

>We have a very big app under VFP (may be 200 tables), 50 projects, no

>documentation (!), no notes in the prg (!!), written by different peoples=

at

>different times, ...

>

>After a period of 'revamping' (I mean that I am going to try to improve the

>app may be for 6 months), my customer want to have a C/S version with

>Pervasive and/or SQL SERVER. Do you think it is a hard work ? What he want

>to know is : will it take a day, a month, a year, a century ???

>

>TIA

>J. MAURICE @Grenoble.France.Europe UFPRC - Foxil

>Pour comprendre la r=E9cursivit=E9, il faut d'abord comprendre la=

r=E9cursivit=E9

©2001 Dan Covill