Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting records into SQL Server fails at 362,240
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00423374
Message ID:
00423819
Vues:
12
>I'm trying to insert 1.5 million records from a Visual Foxpro table into a SQL
>Server table via remote views but my insert keeps failing at a specific number
>of records (362,240).

Hmmm. Have you considered copying to a text file, and then importing it into SQL through the bcp command? This might be more appropriate that running 1.5 million logged inserts...
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform