Exporting Data with gsqlcmd

gsqlcmd allows you to export data from databases in various formats, including plain text, CSV, XML, JSON, and HTML.

The output format is determined by the file extension you provide.

Here are some example commands:

gsqlcmd exec master "select name from sys.databases" databases.txt
gsqlcmd exec master "select name from sys.databases" databases.csv
gsqlcmd exec master "select name from sys.databases" databases.xml
gsqlcmd exec master "select name from sys.databases" databases.json
gsqlcmd exec master "select name from sys.databases" databases.htm

You can also specify the output format explicitly using the following options:

• /asText
• /asCsv
• /asHtml
• /asXml
• /asJson

For example:

gsqlcmd exec master "select name from sys.databases" /astext > databases.txt
gsqlcmd exec master "select name from sys.databases" /ascsv  > databases.csv
gsqlcmd exec master "select name from sys.databases" /asxml  > databases.xml
gsqlcmd exec master "select name from sys.databases" /asjson > databases.json
gsqlcmd exec master "select name from sys.databases" /ashtm  > databases.htm

gsqlcmd offers numerous options to customize the output. For more details, check the Configuring Output topic.

You can also place SQL export scripts in separate files and use a mask for output files, like this:

gsqlcmd exec db *.sql *.htm