Re: VFP and SQL SERVER

Author: Ed Leafe

Posted: 2001-05-29 at 09:39:49

On 5/29/2001 6:28 AM, jsm.maurice supposedly said:

>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 ???

A lot depends on how your app accesses the data. Doing the actual

migration, while not simple, is at least straightforward. But modifying

your app to work with remote data is something else altogether.

If you are currently using views to VFP data, you shouldn't have too

much of a hill to climb. But if you are currently doing direct access to

tables, you'll have to re-think that approach, since it won't work in a

C/S design.

___/

/

__/

/

____/

Ed Leafe

http://leafe.com/

©2001 Ed Leafe