RE: VFP and SQL SERVER

Author: Vlad Grynchyshyn

Posted: 2001-05-29 at 13:44:19

Hi!

It will take at least 1 year.

Or it will tak 6 months - 3 to investigate the application logic, 3 to

re-create the application from zero with use of the SQl Server as a

back-end.

I'm saying so because the application made originally for VFP tables (or

even for FPD) is hard to convert to SQL Server, specially, of it was not

originally built using views and appropriate pre-cautions related to use

this application with SQL Server database. It is much more simple to

re-create it in such case than just convert. Converting will require to

review all code and make a patches, that, of course, very hard with huge

amount of code, as well as application will work inefficiently in such ca=

se.

When you make a good investigate of business logic of application, you wi=

ll

have ability to re-create it with required improvements that will be bett=

er

from performance point of view. There are also a lot of differences betwe=

en

VFP and SQL Server applications and database, so in many cases you will

require to know the business logic of these parts anyway. Making partial

investigates for such cases, code review for patchinig for SQl Server, al=

l

changes, etc etc will take so many time, that you even cannot imagine. We

had similar problem recently with much more little applications, and we h=

ad

a lot of troubles to convert it...

-----Original Message-----

From: profox@leafe.com [mailto:profox@leafe.com]On Behalf Of jsm.maurice

Sent: Tuesday, May 29, 2001 1:29 PM

To: Multiple recipients of ProFox

Subject: VFP and SQL SERVER

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 ans=

wer

!!

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 t=

he

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 wan=

t

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=E9cur=

sivit=E9

©2001 Vlad Grynchyshyn