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