Click here to Skip to main content
12,246,032 members (34,577 online)
Click here to Skip to main content
Articles » Database » Database » General » Alternatives
Alternatives (1)
Add your own
alternative version

Tagged as

Stats

101.7K views
23 bookmarked
Posted

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

, 3 Jan 2012 CPOL
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.

11 Jan 2012
THE 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)

Share

About the Author

bluesathish
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 | ;-)

| | Privacy | Terms of Use | Mobile
Web02 | 2.8.160426.1 | Last Updated 3 Jan 2012
Article Copyright 2012 by bluesathish
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid