Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to move data into a SQL-Server database?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00540114
Message ID:
00540651
Views:
26
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform