[EMAIL PROTECTED] wrote:
From: MB Software Solutions <[EMAIL PROTECTED]>
I'm putting new functionality into some software that started using VFP
(and still does primarily) as the backend, but for these new things I'm
creating the tables in a MySQL database. I'm aware of some caveats of
doing this (like synchronization, and as such, I'm avoiding it where
this would be the case but instead really just using it for lookup
tables and user administration/rights), but wondered what other caveats
folks might think of for this?
Caveats?
1) How was your key generated in VFP data?
Same as in MySQL for some tables: AutoIncrement integer keys. For
others, manual key generation with GetNextID() functionality from legacy
Fox examples.
2) How did you verify the key for secondary immediate use?
Huh?
3) Why would you do a mix and not convert to all MySQL?
Answered that already: am integrating as new stuff comes online rather
than double-development (VFP for new features while building equivalent
MySQL side). This should help bring it to fruition sooner, imo.
4) That reindex code is not longer going to be used.
Ok...no big deal. A plus for sure with MySQL.
5) Exclusive use, what for?
Right...not used in my app, so non-issue.
6) Pack This!
See answer to #4 above.
7) All your code that referenced and ! deleted() will need to be
changed.
Never did that, so non-issue.
8) Do you know how to make MySQL backups and restore from them?
Yep.
9) Do you ever truncate the ib_logfile?
There are various log files in MySQL, but that's not really for this
thread, is it? :-)
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"
_______________________________________________
Post Messages to: [email protected]
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.
