BCP - Linux vs. Windows Version

Phillip H 86 Reputation points
2023-06-30T17:05:16.2433333+00:00

I'm using BCP for linux / mac (version 18.2.0001.1) to load data to an Azure SQL Database. I can pass a token using -G and -P with a path to a saved token file, as described in the linux guide on learn.

I'd like to do something similar in Windows, but it doesn't appear that the latest bcp windows version (15.0.4298.1) can use a token w/ the -G & -P parameters. If I use those parameters, it tries to use Azure Active Directory authentication directly. I'm taking this from the command list on learn.

My questions are:

1 - Is there any way to run the windows version of bcp w/ a token?

2 - Is there any way to run the linux / mac version of bcp on windows (other than something like docker/WSL)?

3 - If no to both of the above, is there any plan to add this functionality to the windows version or merge the two versions feature sets in some way?

Azure SQL Database
{count} votes

Accepted answer
  1. Erland Sommarskog 115.3K Reputation points MVP
    2023-06-30T21:18:38.75+00:00

    It seems indeed that there is a difference between the Linux and Windows versions. That's a bit unfortunate.

    I think the best advice I can give is to file a suggestion on https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.