Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to move data into a SQL-Server database?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00540114
Message ID:
00540651
Vues:
15
>My strong reason is to get the best
> performance possible. I'd be parsing
> and uploading millions of records per
> run and I want to cut the amount of
> file IO to the absolute minimum.
Sounds like an interesting process.

>If I have to use ODBC or OLE, so be it.
> I'm trying to find out if I can bypass
> these intermediaries and write directly
> to the SQL Server database.
In that case the BCP will probably be your best bet. In fact, as far as I remember, BCP does not even enforce referencial integrity rules which will make the import process a lot faster.
Hector Correa
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform