search

microsoft / mssql-docker

Official Microsoft repository for SQL Server in Docker resources
MIT License
1.72k stars 758 forks source link

bcp out -x is no working #662

Open sm250451 opened 3 years ago

sm250451 commented 3 years ago

When running bcp out -x on Linux container it is not working. But bcp out -x is working on Windows (export xml format). We are running vertion : bcp -v : 17.6.0001.1

kevunix commented 2 years ago

-x also does not exist on 18.1.0001.1


usage: /opt/mssql-tools18/bin/bcp {dbtable | query} {in | out | queryout | format} datafile
  [-m maxerrors]            [-f formatfile]          [-e errfile]
  [-F firstrow]             [-L lastrow]             [-b batchsize]
  [-n native type]          [-c character type]      [-w wide character type]
  [-N keep non-text native] [-q quoted identifier]
  [-t field terminator]     [-r row terminator]
  [-a packetsize]           [-K application intent]
  [-S server name or DSN if -D provided]             [-D treat -S as DSN]
  [-U username]             [-P password or tokenfile]
  [-T trusted connection]   [-v version]             [-R regional enable]
  [-k keep null values]     [-E keep identity values][-G Azure Active Directory Authentication]
  [-h "load hints"]         [-d database name]
  [-Y encrypt option]       [-u trust server certificate]```