Post reply

Question on BCP and Azure

  • March 19, 2020 at 11:14 am

    #3735534

    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

  • March 19, 2020 at 3:00 pm

    #3735608

    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.

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

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

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