>>But does the Sedna handle the actual transfer of data as well, and would I be >>able to write a stand-alone utility with it that I can send to the client (who only has the vfp9 runtimes)? If so, I'll take a look. Thanks!<<
The new Upsizing Wizard uses the XML Bulk inserts to move the data. Doug Hennig blogged about the performance increases: http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html I don't know if the licensing for the Sedna components has been released, but they are part of Xsource and the licensing agreement for that allows developers to make changes and release them. As far as running it in a VFP executable, it should not be hard to do. There is a separate engine component too so you can automate it programmatically to your liking. You do not need the wizard interface. 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 05:07 PM To: [EMAIL PROTECTED] Subject: Re: Quickest way to load VFP tables to MSSQL? Rick Schummer wrote: >>> 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). > Well, at this point I'm 90% done. Wrote the utility, it works fine, just need to replace hard-coding with vars to make it flexible, then iterate through my DBC and call it. But does the Sedna handle the actual transfer of data as well, and would I be able to write a stand-alone utility with it that I can send to the client (who only has the vfp9 runtimes)? If so, I'll take a look. Thanks! [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.
