Click here to Skip to main content
15,867,756 members
Articles / Programming Languages / SQL

SQL Bulk copy method to insert large amount of data to the sql database

Rate me:
Please Sign up or sign in to vote.
5.00/5 (9 votes)
3 Jan 2012CPOL3 min read 176.7K   23  
Fastest and most efficient method to insert large amount of records to a SQL Server database from our system generated datatable.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

Please Sign up or sign in to vote.
11 Jan 2012THE BLACK TIGER
Thank you for this article, okay it's technical.But we can use other methods considered as more efficient. *For Microsoft SQL Server, we can use bulk copy program(bcp). The tool is embeddedwithin SQL server so you can invoke it inside your application - whatever language you use....

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior)
India India
Bluesathish was his alice name, He has been Working with Microsoft Visual studio from the past 7 years and worked its versions like VS2003, VS2005, VS2008 and Present VS2010. And in his free times he likes to play cricket and videogames, sometimes surfing in codeproject.

He likes to share things/thoughts/ideas which he knew, I think thats what he subscribed in CP Wink | ;-)

Comments and Discussions