filePro and MySQL (was Re: Filepro-list Digest, Vol 63, Issue 23)

Kenneth Brody kenbrody at spamcop.net
Wed Apr 22 17:32:06 PDT 2009


Fairlight wrote:
> Simon--er, no...it was Ryan Powers--said:
[...]
>> It isn't a straightforward transfer because that would be
>> impossible. There are several field changes but the data remains intact,
>> albeit the edits will not be. I considered retaining the edits but I've
>> been down that road before and it really isn't worth the trouble. IMO it
>> is best to do a text transfer and then clean and convert the field types
>> in MySQL once you have them in the tables.
> 
> In your defense, I think maintaining the edits is a complete waste of time.
> I see edits as an application-level function, not a storage-level function.
> If the data remains sacrosanct during transfer, that's all that should
[...]

You can, of course, do some mapping.  For example, keeping dates as dates, 
and numbers as numbers.  And, if you're feeling adventuresome, yesno to boolean.

-- 
Kenneth Brody


More information about the Filepro-list mailing list