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?