Hello,
I'm working under a deadline to transfer a DBC of VFP 9.0 tables to MS
SQL server. Before I get too far into it, I thought I'd ask for better
ideas than what I'm doing.
The constraints:
Upsizing wizard is out of the question.
Won't be able to use any MS SQL tools to pull the data in, it has to be
a Push from VFP via ODBC.
Have:
VFP9
Tables may be assumed to be created correctly on the backend, with all
rights
Transfer will be Localhost
My current idea is to create a temporary XFER DBC. Then I open the DBC
containing the local tables to be transfered, Get the list of tables
from aDBObjects(), and iterate through the tables.
For each table:
Create a REMOTE view on the fly on the backend table, with correct
send updates, etc, etc.
Set optimistic table buffering
Append into the Remote view from the local table
Issue tableupdate()
Does this sound reasonable? Any faster/better way to do it? I know
nothing at all about what cursoradoptors can do. Can they do the job,
and if so, would the couple of hours I lose learning to use them pay
off? (Need to deliver tomorrow)
Would appreciate any ideas. I'll be here, working on the above in the
meantime. :-)
_______________________________________________
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.
