On Thu, Oct 14, 2010 at 9:01 AM, MB Software Solutions, LLC <[email protected]> wrote: > On 10/14/2010 9:57 AM, Stephen Russell wrote: >> On Thu, Oct 14, 2010 at 9:49 AM, James E Harvey<[email protected]> >> wrote: >>> Thanks, I'll take a look at the upsize wizard. >> -------------- >> >> Bad idea. >> >> 100% guarantee of problems if you have 25 meg of data or more. >> >> >> > > > Are you saying this from personal experience? --------------------
The 3 times I attempted it were all failure. Diff clients and diff version of SQL Server. 7, 2000 for SQL Server. In the pre SQL Server 2005 days you would use a DTS, 2005 and on you use a SSIS job. I could clean house in all SS tables (2000 version) and then import 600 meg of data into SQL Tables as well as kick off 50+ conversion scripts to take raw data and normalize it as well as combine for BI reporting. Took 45 seconds to 90 depending on other jobs running on server. Pure WAG here but I thought that VFP was doing a transaction for each row and after that TRAN commit it would retire the connection it had. Only way to justify spending 15 min or more to attempt to load the same data. That data was FPD2.6 free tables. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
