Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS possible?
Message
From
08/04/2005 15:38:31
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01002704
Message ID:
01002823
Views:
26
>this sounds like a "winner". Thanks a lot!

And it works too! I do this daily with a few tens of thousands of records from a daily process (DBF) to a SQL server like table. It started years ago as a DBF only program. Overgrew DBFs (2GB barrier) in 2004 so we changed to SQL Server but left the whole nightly batch process as is in a DBF. The only changes were done to read from the history (big) table to check for possible duplicates.

To do an INSERT INTO for each record was slow and created SQL Log problems. A batch DTS every day solved the problem nicely.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform