Sunday, March 04, 2018

mssql-cli, the command-line for querying SQL Servers

The public preview was announced in December last year. Now there is an update.

Read here.

You can download mssql-cli from here:

Using mssql-cli you get to do all this:

    T-SQL IntelliSense
    Syntax highlighting
    Pretty formatting for query results, including Vertical Format
    Multi-line edit mode
    Configuration file support

You can install mssql-cli if you have Python on your computer. For Windows you can install Python from here and make sure it is added to your PATH.


Install the tools for Mac El Capitan and Sierra

/usr/bin/ruby -e “$(curl -fsSL”
brew tap microsoft/mssql-preview
brew update
brew install –no-sandbox msodbcsql mssql-tools
#for silent install ACCEPT_EULA=y brew install –no-sandbox msodbcsql mssql-tools


No comments: Protection Status