Index
2000-12-15 19:42 – Tom Kim : VFP and SQL Server DTS
2001-05-29 09:10 – Dan Covill : Re: VFP and SQL SERVER
2001-05-29 09:24 – Russell, Stephen : RE: VFP and SQL SERVER
2001-05-29 09:39 – Ed Leafe : Re: VFP and SQL SERVER
2001-05-29 10:39 – Carl Karsten : Re: VFP and SQL SERVER
2001-05-29 12:28 – jsm.maurice : VFP and SQL SERVER
2001-05-29 13:44 – Vlad Grynchyshyn : RE: VFP and SQL SERVER
2001-05-29 14:05 – Anders Altberg : Re: VFP and SQL SERVER
2001-05-30 14:41 – Nancy Folsom : RE: VFP and SQL SERVER
2001-05-30 15:37 – Nancy Folsom : RE: design happens. was: VFP and SQL SERVER
Back to top
VFP and SQL Server DTS

Author: Tom Kim

Posted: 2000-12-15 19:42:32   Link

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

===================================

©2000 Tom Kim
Back to top
Re: VFP and SQL SERVER

Author: Dan Covill

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

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
Back to top
RE: VFP and SQL SERVER

Author: Russell, Stephen

Posted: 2001-05-29 09:24:10   Link

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

©2001 Russell, Stephen
Back to top
Re: VFP and SQL SERVER

Author: Ed Leafe

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

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
Back to top
Re: VFP and SQL SERVER

Author: Carl Karsten

Posted: 2001-05-29 10:39:41   Link

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é

>

>

>

>

>

>

©2001 Carl Karsten
Back to top
VFP and SQL SERVER

Author: jsm.maurice

Posted: 2001-05-29 12:28:32   Link

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

©2001 jsm.maurice
Back to top
RE: VFP and SQL SERVER

Author: Vlad Grynchyshyn

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

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
Back to top
Re: VFP and SQL SERVER

Author: Anders Altberg

Posted: 2001-05-29 14:05:08   Link

"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

>

>

>

>

>

>

©2001 Anders Altberg
Back to top
RE: VFP and SQL SERVER

Author: Nancy Folsom

Posted: 2001-05-30 14:41:16   Link

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

©2001 Nancy Folsom
Back to top
RE: design happens. was: VFP and SQL SERVER

Author: Nancy Folsom

Posted: 2001-05-30 15:37:22   Link

Carl-

> Design happens. I like it. You should copyright it.

I'd settle for client buy-in to the concept.

-Nancy

©2001 Nancy Folsom