DTC? John
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Thursday, February 01, 2007 2:13 PM To: Profox Subject: Quickest way to load VFP tables to MSSQL? 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. :-) [excessive quoting removed by server] _______________________________________________ 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.
