Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Batch update to SQL Server??
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01545010
Message ID:
01545014
Vues:
56
>>I have a cursor that has about 80,000 records in it. I need to upload all of the records to SQL server. Is there a quick way to do this in some sort of batch?
>
>I think sending it as XML to SQL Server may be one of the options. Another option is to save as CSV and load from CSV using Import/Export wizard

hmmm...I will take a look at doing it as XML. Don't want to use the wizard as this is going to be part of a program that runs every night.
I'm just trying to find a way to make it run quickly :)
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform