>>Upsizing wizard is out of the question.<< I can highly recommend you test out the new *Sedna* Upsizing Wizard if the structures are the same (not sure if this was a reason for the constraint of if you were thinking the old Upsizing wizard stinks). It has moved several of my VFP DBCs and the data to SQL Server 2000 and SQL Server 2005 without any issues. You can test this (including the download and time) in less than a couple hours depending on the quantity of data you are moving. The Sedna components work fine on VFP 9 SP1 (no need to get SP2 involved).
The XML Bulk updates are way faster than the remote view approach. Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Thursday, February 01, 2007 03:13 PM To: [EMAIL PROTECTED] 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.
