0

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?

Improve this question
3
  • 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

0

Reset to default

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.