On Thu, Apr 30, 2009 at 7:51 AM, Ted Roche <tedroche@gmail.com> wrote:

aCK! Stupid send key...

>

> If only it were that easy :)

>

> I worked on the migration of a large commercial web site, in

> hand-coded VFP, from direct DBF manipulation to calling client-server

> code. It required examining and recoding not just all the standard SQL

> INSERT...

UPDATE and DELETE, but also REPLACE, APPEND, SCAN, LOCATE/CONTINUE,

SEEK, etc., etc.

Most of the available frameworks have the ability to switch their use

of views or CursorAdaptors from local to remote, but there's still a

lot of fine-tuning to be done.

And then there are the issues of cleaning up the data: handling empty

fields that need to be NULL in the target, converting dates to

datetimes (and back), and so forth.

It's non-trivial. Usually not very exciting work, but resource

intensive. Think of it as a full-employment plan.

--

Ted Roche

Ted Roche & Associates, LLC

http://www.tedroche.com