Search code examples
sql-serverazure-active-directoryazure-sql-databasebcpazure-synapse

Using BCP Utility with Azure Active Directory Integrated

I'm trying use the BCP Utility to load data into a Azure SQL Data Warehouse, I did the download in the link below;

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

But after install, when I'm in prompt and I check the version of my BCP, the version is 14.0 and I've install 15.0.

I want use the 15.0 version because I need use the command -G to autentication with Azure Active Directory Authentication.

Anyone had the same problem? Any suggestion?

Thanks.

Gustavo Gouveia.

Solution

  • I download BCP Utility from the same link with you. My system is Win10 and I choose the Download Microsoft Command Line Utilities 15.0 for SQL Server (x86).

    After install completed, I run BCP -V command, I found that the version is not 15.0. enter image description here

    I also run sqlcmd -? command and get the same version. enter image description here

    Actually I haven't fount the download link of the 15.0 version from the offical site.

    I don't know why this happens. I have sent an email to Azure and wait the answer.

    Please wait for my update.