Why wouldn't you want MySQL to handle all the heavy lifting of the data,
including parent and child tables, auto-incrementing of primary keys,
all indexes, all foreign key constrains (eg RI), all processing within
transactions, etc? Then MySQL would retrun a record set based on SQL 92
to the VFP GUI. The data could be manipulated with the VFP GUI/Program,
and then updated back to MySQL.
Regards,
LelandJ
MB Software Solutions wrote:
Ted Roche wrote:
Two sentences, 31 words and 46 words, respectively, not expanding
contractions.
MB: Take a deep breath.
Talk slowly. Small sentences.
Brevity was always a challenge for me. Bill and I perhaps share that
in common. <haha---jk Bill!>
What caveats?
Using MySQL means you don't have to pack, it's easier to delete and
insert than to reckon what's changed and mix delete/insert/update
logic, that transactions work more reliably (InnoDB) and with
point-in-time recovery.
No no, I know all the good reasons of why to use MySQL...that's not
what I meant.
Explain what you mean about synchronization.
What are you looking for here? What are your questions?
When shops have tried to use a combination of VFP and SQL Server, it's
caused a lot of pain in terms of making sure the VFP data shakes well
with the SQL Server data. Now in those instances, they probably
didn't normalize enough and hence they needed to make repetitive
changes to make sure the VFP and SQL Server values were the same
("sync-ed"). In my system, I'm integrating user administration where
the MySQL tables hold the user ids, rights, etc. Some of the MySQL
data (userid or some unique integer keys for example) will be saved in
the VFP tables. I don't see a real harm with that....do you?
Is there a "best strategy" for migrating an existing, in-use app from
VFP to a non-VFP backend (in my case, MySQL)?
<breathing out...>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.