Whil Hentzen (Pro*) wrote:
Ted Roche wrote:
On 8/5/06, Michael Babcock <[EMAIL PROTECTED]> wrote:
What steps do you take when preparing to migrate data stores from DBFs
to remote databases like SQL Server?
It sounds like you will not be executing a complete migration, but
rather having to synchronize a set of DBFs with a backend server for
some period of time. That's an app that needs to be written.
Yeah, what he said.
And one last step. Once you've done the migration, and your data is in
the new home, how do you know you did it correctly? Are you sure that
all of your records on 2/29/2004 made it? What about the customers
with apostrophes in their last names (O'Meara, O'Mye, etc.)?
You need to build another app (or a module of the first one) to prove
your data made it. The data, all the data, and nothing but the data....
Right. It's amazing to me in the years I've been doing this (less than
you and Ted for sure) that the data integrity is not as I would expect
it to be many times. Garbage here and there, etc., caused by either
incomplete or incorrect designs (most likely "rushed" to get it up and
going). "Plan? What's that?" <g>
--
Thanks,
--Michael
_______________________________________________
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.
