CODEWITHSUNDEEP
.netsqlsql-serversilverlightsql-server-2008
itb564
itb564

Reputation: 223

BulkCopy Vs BCP Insert

I need to insert a huge amount of data into different tables within my database. Which options can I choose so that performance will never be an issue? (It is a silverlight application and I will run this on the server from the client side.) I found some options like BulkCopy in SMO and BCP Insert. Which would be the best for my scenario?

Upvotes: 2

Views: 3956

Answers (1)

user1240792
user1240792

Reputation: 334

You can use the SqlBulkCopy class instead. I've been using it many times, it's very efficient and easy to use.

Take a look at this post: http://social.msdn.microsoft.com/Forums/eu/adodotnetdataproviders/thread/dcc7a701-9acf-4c2f-a5d7-1fcb4dbb05f2

Example for using it: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

Upvotes: 3

Related Questions