Post reply

Is bulkcopy still fast than insert...select statement at the same server?

  • November 4, 2011 at 10:04 am

    #246322

    I am learning bulkcopy from the link below

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

    It said that

    "If the source and destination tables are in the same SQL Server instance, it is easier and faster to use a Transact-SQL INSERT … SELECT statement to copy the data."

    I want to use this utility to make a table from a views in another database but in the same server.

    Is bulkcopy still fast than insert...select statement?

  • November 4, 2011 at 10:19 am

    #1403372

    It is obviously not true , you can easily create a two million records table and try to move the records to another table on the same instance by INSERT/SELECT and by BCP and see that the BCP is much faster.

    However, i saw instances where SSIS is much faster than BCP.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply