Post reply

BCP program VS BULK INSERT query

  • August 22, 2016 at 7:05 am

    #400608

    Hi Folks,

    What is the difference between BCP program and BULK INSERT. Are they both the same in terms of performance? I am trying to find a solution for bulk load from an OLTP system(on-prem) to Azure data warehouse.

    Thanks!

  • August 22, 2016 at 9:44 am

    #1896689

    SQL!$@w$0ME (8/22/2016)

    Hi Folks,

    What is the difference between BCP program and BULK INSERT. Are they both the same in terms of performance? I am trying to find a solution for bulk load from an OLTP system(on-prem) to Azure data warehouse.

    Thanks!

    Bulk Insert is a tiny bit faster but no so most people would notice.

    Not sure you're using the right tool, though. I'm not an Azure user but I believe there are easier ways to upload to Azure.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 22, 2016 at 10:54 am

    #1896709

    Thanks Jeff. Do you think SSIS is a possible solution?

  • August 22, 2016 at 11:12 am

    #1896714

    SQL!$@w$0ME (8/22/2016)

    Thanks Jeff. Do you think SSIS is a possible solution?

    All you're trying to do is upload stuff to Azure, correct? Like I said, I'm no expert there but there are plenty of good articles on how to do such a thing and, IIRC, not many of them actually used BCP, BULK INSERT, or (ugh!) SSIS.

    Hopefully, my responses to all of this will "bump" this thread often enough for someone that does know the best answer to come to your rescue. 🙂

    Shifting gears a bit... I can't speak for you or others but I avoid SSIS like the plague and have successfully eliminated it from my environment and we have a fairly intense, large batch, bi-directional ETL environment.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 22, 2016 at 12:00 pm

    #1896723

    Something like the following Google search may be a help...

    https://www.google.com/?gws_rd=ssl#q=copy+local+data+to+azure

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 22, 2016 at 12:18 pm

    #1896730

    Yes SSIS is possible for both azure SQL DB and DWH

Viewing 6 posts - 1 through 5 (of 5 total)

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