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 https://raw.githubusercontent.com/Homebrew/install/master/install)”
brew tap microsoft/mssql-preview https://github.com/Microsoft/homebrew-mssql-preview
brew update
brew install –no-sandbox msodbcsql mssql-tools
#for silent install ACCEPT_EULA=y brew install –no-sandbox msodbcsql mssql-tools

"

https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/03/sql-server-command-line-tools-for-mac-preview-now-available/

No comments:

DMCA.com Protection Status