General information
Forum:
Microsoft SQL Server
Category:
Database management
BCP is the only fast way I know of getting data into SQL server. I am not sure what kind of throughput you are looking for but in my experience, bcp has been able to handle up to 5000 rows per second. Also since bcp is a non-logged operation, SQL server does not write the transactions to the t-log which is why it is faster than SQL-insert command.
-Kurt
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only