search

fivestack / bcp

This is a python utility that allows users to import/export data to/from a database.
https://bcp.readthedocs.io/en/latest/
Apache License 2.0
12 stars 3 forks source link

Missing `-o` option on Mac #17

Open jseabold opened 4 years ago

jseabold commented 4 years ago

I don't have the -o option, so this throws an error.

| $ bcp -h
usage: 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]
  [-T trusted connection]   [-v version]             [-R regional enable]
  [-k keep null values]     [-E keep identity values]
  [-h "load hints"]         [-d database name]
| $ bcp -v
BCP - Bulk Copy Program for Microsoft SQL Server.
Copyright (C) Microsoft Corporation. All Rights Reserved.
Version: 17.5.0002.1
mikealfare commented 4 years ago

Hmm, I find it interesting that MS would change the API in that way, either by OS or by version. Apparently this is only supported on Windows then. Also, it looks like you have version 17 of BCP, whereas Microsoft lists version 15 as their current release according to their docs. I'll add the specific version of BCP and that this is limited to Windows (for now) to the README.md so that it's explicit. I'll keep this issue open as a backlog item in the future.

jseabold commented 4 years ago

Thanks, yeah, I just noticed that version mismatch too. I think it has some more incorrect information around AD authentication too.

On Fri, Apr 3, 2020, 1:00 PM Mike notifications@github.com wrote:

Hmm, I find it interesting that MS would change the API in that way, either by OS or by version. Apparently this is only supported on Windows then. Also, it looks like you have version 17 of BCP, whereas Microsoft lists version 15 as their current release according to their docs. I'll add the specific version of BCP and that this is limited to Windows (for now) to the README.md so that it's explicit. I'll keep this issue open as a backlog item in the future.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/fivestack/bcp/issues/17#issuecomment-608575010, or unsubscribe https://github.com/notifications/unsubscribe-auth/AACIJZBCUSLVBR3R7W63XCDRKYONFANCNFSM4L4JX3FQ .