Post reply

Another Bulk Insert Question

  • February 23, 2011 at 2:52 pm

    #247249

    Is bulk insert only from file -> table?

    Or can you use bulk insert from table -> table without having to create a file using bcp.

  • February 23, 2011 at 3:19 pm

    #1290663

    Are you asking about a scenario when moving data between two tables on different instances?

    I'll assume yes.

    BULK INSERT will not do this but OPENROWSET or OPENQUERY using a Linked Server will.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 23, 2011 at 10:19 pm

    #1290729

    Khades (2/23/2011)

    Is bulk insert only from file -> table?

    Yes.

    Or can you use bulk insert from table -> table without having to create a file using bcp.

    In 2008, you can often achieve minimally-logged bulk copy using an ordinary INSERT...SELECT command. See http://msdn.microsoft.com/en-us/library/dd425070.aspx

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

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

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