Question on BCP and Azure

  • itmasterw 60042

    SSCrazy

    Points: 2785

    Hi,

    I have a Vb.Net app that is using BCP call to SQL Server to export data from a CSV file to SQL Server.

    This works fine for our SQL Server that is on our premise but is not working for our SQL Server on Azure.

    At first, I thought maybe it is the connection string, but in other places in the application we are able to query the database; so I do not see that being the issue.

    So, I am wondering if there is some configuration or enabling that needs to be done for the BC to work on Azure?

    Is there something that I have to do for the firewall or permissions somewhere?

    Thank you

  • Jeff Moden

    SSC Guru

    Points: 996655

    I don't use Azure and I've not used VB in a million years.  However, the following link seems to have a fair bit of info that you might find applicable for using BCP on Azure.

    https://docs.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver15

    --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".
    "If "pre-optimization" is the root of all evil, then what does the resulting no optimization lead to?"

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

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

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