You must Sign In to post a response.
  • Category: ASP.NET

    How to Bulk insert in SQL SERVER 2005

    Hello ,

    I want to insert data it in SQL SERVER 2005 database will be around like 9000000 records.

    selection of data is in HTML javascript (ASP.NET) . that data I have to insert.

    I want use Bulk Insert OR Bulk Copy.

    Which will be the best way to Insert data in this Kind of Situation.


    Regards,
    Jeevan Joshi
  • #764050
    Hai Jeevan,
    The major difference between the Bulk Insert and Bulk Copy depends on the situations:
    --> If there is the scenario where we want to load file within SQL Server, because this file will be accessible from SQL Server, then we can use the BULK INSERT.
    --> If the file is not under the Sql Server access, and we have the load it from some other location then we can go with the Bulk Copy.
    Hope it will be helpful to you.

    Regards,
    Pawan Awasthi(DNS MVM)
    +91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
    pawansoftit@gmail.com

  • #764065
    Hi Jeevan,

    You should go with Bulk Copy.

    You can refer following link:
    http://www.codeproject.com/Tips/309564/SQL-Bulk-copy-method-to-insert-large-amount-of-dat

    Regards,
    Shashikant Gurav (Programmer II)
    shashikantgurav22@gmail.com


Sign In to post your comments