Hi,
I need to be able to programmically control DTS from VFP. Has anyone done
this or has any suggestions on resources? Thanks --Tom
===================================
Tom Kim
Advanced Systems Integration
949-261-5476
949-261-0426 Fax
tkim@advancedsystemsintegration.com
===================================
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
Sorry to say that it would probably take a year +. If you were very =
fluent
with VFP and your own framework or a third party one well rehearsed I =
might
cut that time by 1/4. =20
It seems that it's a huge app with now real structure (documentation). =
You
will find that aspects will be consistent between a coder, but how that =
will
fit into the whole is another story.
Good thing is that it's going to be as long for any other group to come =
in
and re-do it.
Keeping it in VFP may make it easier, only if you are good with VFP. =
It may
make it harder as your first real app in VFP????
__Stephen
-----Original Message-----
From: jsm.maurice [mailto:jsm.maurice@wanadoo.fr]
Sent: Tuesday, May 29, 2001 5:29 AM
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 =
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
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
Take a look at the notes at
http://fox.wikis.com/wc.dll?Wiki~UpsizingWizard~VFP
Carl
----- Original Message -----
From: "jsm.maurice" <jsm.maurice@wanadoo.fr>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Tuesday, May 29, 2001 5:28 AM
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
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écursivité, il faut d'abord comprendre la récursivité
>
>
>
>
>
>
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)=2E But I need the answ=
er
!!
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, =2E=2E=2E
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=2E 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=2E MAURICE @Grenoble=2EFrance=2EEurope UFPRC - Foxil
Pour comprendre la r=E9cursivit=E9, il faut d'abord comprendre la r=E9cursiv=
it=E9
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
"Pervasive and/or SQL SERVER"
Go for the OR.
-Anders
----- Original Message -----
From: "jsm.maurice" <jsm.maurice@wanadoo.fr>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Tuesday, May 29, 2001 12:28 PM
Subject: VFP and SQL SERVER
> Note : this mail is a sort of demo about Profox I am giving to one of m=
y
> 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 peopl=
es
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 w=
ant
> 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=E9c=
ursivit=E9
>
>
>
>
>
>
J. Maurice-
> 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 ???
Okay, now for the correct answer <bg>. You don't know, and neither does
anyone else here. However, what you do know is that you have, probably about
a month, give or take, of fulltime work to do the functional
specification/requirements gathering which _will_ tell you how long it will
take and what implementation makes the most sense for your client.
If you have a 3 story house that needs to be remodeled, and you ask me how
long will it take, I'd tell you that first we need some plans, we need to
know where you're going, what you've got, and what can be reused. _Then_ you
get a bids on doing the construction, yes? It doesn't really tell me much to
say it's 3 stories and has has 4 bedrooms. I don't know what shape the
wiring is in, if there's termite damage, or whether you want cosmetic
changes or major floor plan changes.
So, the best situation is to contract to do the functional specs and req.
gathering at the end of which you and your client have a blueprint you can
study and use to specify the implementation. For example, he/she might find
that a SQL-Server solution will be too many $$$$ and staying with Fox, but
planning for an upsizing later will make the most sense.
This does NOT cost more money--design happens whether you plan for it not,
the only question is will it be good or will it be thorough, or will it
drive everybody on the project nuts? This does NOT add more time, either,
because design happens, either in the beginning before code has to be thrown
out and then incrementally thru the life of the project, or it gets done
over and over and drives everyone nuts. See above.
-Nancy
Carl-
> Design happens. I like it. You should copyright it.
I'd settle for client buy-in to the concept.
-Nancy