Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DTS possible?
Message
De
08/04/2005 15:38:31
 
 
À
08/04/2005 15:10:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01002704
Message ID:
01002823
Vues:
18
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform