The DTC takes a fraction of the time of other update methods. If it's a one time update, use the DTC wizard. If it is an ongoing deal, look at saving the scripts. The data to be updated needs to be on the same server as the SQL Server for it to work as fast as possible.
John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Virgil Bierschwale Sent: Thursday, February 01, 2007 5:29 PM To: 'ProFox Email List' Subject: RE: Quickest way to load VFP tables to MSSQL? I always preferred the brute force method.. Something like this if my memory works correct Use ODBC Sqlconnect() Input string = "Insert into ???" Scan sqlexec(input string) select table endscan Virgil Bierschwale http://www.bierschwalesolutions.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Thursday, February 01, 2007 4:10 PM To: ProFox Email List Subject: Re: Quickest way to load VFP tables to MSSQL? john harvey wrote: > DTC? Bless you! :-) (I know not of this DTC. I am but a simple caveman programmer. Your scientists found me in a block of Ice and thawed me out. This DTC frightens and confuses me) :-( [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.
