Skip to content

erickangMSFT/cli-docker

Repository files navigation

SQL Server Command Line Tools

Preparation

  1. Install Docker CE on your PC. Download Docker-CE from store.docker.com

  2. Install docker-compose

    pip install docker-compose
  3. Install SQL Ops Studio from https://aka.ms/sqlopsstudio

Simple Demo for mssql-cli

  1. Clone this repository
    git clone https://github.com/erickangMSFT/cli-docker.git
  2. Start mssql and mssql-cli docker containers using docker-compose
    cd cli-docker
    docker-compose -f simaple-demo.yaml up -d
  3. Enter mssql-cli docker shell and execute mssql-cli
    docker exec -ti mssql-cli sh
    
    export MSSQL_CLI_USER=sa MSSQL_CLI_PASSWORD=SqlDevOps2017 MSSQL_CLI_SERVER=mssql
    
    mssql-cli
  4. Run demo in mssql-cli prompt
    \?
    --list all databases
    \ld
    
    use WideWorldImporters; --change database
    
    --list all schema
    \ls 
    q
    
    --list all tables with partial word search for 'peop'
    \lt peop
    
    -- request: please add \lsp to list stored procedure
    
    -- open file into mssql-cli
    \e
    
    CTRL + R to search previously exected queries.
    
    F3 to enable multiline query
    
    select top 3 * from sys.databases
    where name like %wide%;
    
    -- 1. Join suggestion for tables and columns
    select top 3 * from "Application"."People" p
    join -- show join suggestion here
    
    --2. Join suggestion for columns
    select top 3 * from "Application"."People" p
    join "Sales"."Customers" c on -- show join suggestion here
    q

Build SQL CLI Tools Docker images: DIY

All docker images are published to https://hub.docker.com/r/ericskang/sqltools. Note that the published images are NOT OFFICIAL and FOR TEST USE ONLY.

  1. Build docker images To build your own docker images, run following.

    ./build_all.sh
  2. Test images To test, execute each step in test.sh

    vim test.sh

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages