On my Mac, I have a docker container running an Ubuntu version of MS SQL. I have a DB running in it and I can access it via Azure Data Studio, and I can view each table individually and export it to CSV using the GUI, but I was hoping to find a way to export all tables to CSV en masse. I have googled it endlessly but have yet to find the command line SQL commands to do this export, and Azure Data Studio seems to only offer one-table-at-a-time exporting.

Can anyone help me out here?

  • Are you looking for bcp?
    – mustaccio
    Apr 6, 2020 at 18:27
  • I am uncertain. I took a look at it, and it is unclear to me as to whether I can use bcp to export every table for me, or if I have to do it table by table.
    – zeeple
    Apr 6, 2020 at 22:26
  • 1
    That was a rethorical question, imposed by SE. You are looking for bcp.
    – mustaccio
    Apr 7, 2020 at 2:38


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.