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