en-UShe-IL
You are here:   Blog > SQL Server on Linux
Register   |  Login

Minimize SQL Server on Linux

  

Installation on Linux Ubuntu (cheat-sheet)

  • Control Your Linux via SSH
    • Using PuTTY shell
    • Using WinSCP file manger
  • Prepare Windows Remote Desktop
    • sudo apt-get update

    • sudo apt-get install xrdp @1

    • sudo apt-get install xubuntu-desktop @2

    • echo xfce4-session >~/.xsession

    • sudo nano /etc/xrdp/startwm.sh
      Add the line xfce4-session before the line: /etc/X11/Xsession

    • sudo service xrdp restart

  • Connect with Windows Remote Desktop  @3

    • Mstsc /v:111.111.111.111 /w:1000 /h:700

    • Open browser and come to this page to continue :-)
  • Remote Connection with VNC - TightVNC
  • Install Visual Studio (code) for Linux
    • Download the newer package
    • sudo dpkg -i code_1.17.0-1507160143_amd64.deb
    • sudo apt-get install -f

    • sudo sed -i 's/BIG-REQUESTS/_IG-REQUESTS/' /usr/lib/x86_64-linux-gnu/libxcb.so.1
  • Install .NET Core
    • sudo sh -c 'echo "deb [arch=amd64] https://apt-mo.trafficmanager.net/repos/dotnet-release/ xenial main" > /etc/apt/sources.list.d/dotnetdev.list’
    • sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys B02C46DF417A0893
    • sudo apt-get update
    • sudo apt-get install dotnet-dev-1.0.4
  • Powershell Package installation instructions
    • Using Ubuntu 16.04, download the Debian package powershell_6.0.0-beta.5-1ubuntu1.16.04.1_amd64.deb
    • sudo dpkg -i powershell_6.0.0-beta.5-1ubuntu1.16.04.1_amd64.deb
    • sudo apt-get install -f @4

    • Open new command shell and execute: powershell
  • Install SQL Server on Ubuntu
    • curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

    • sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

    • sudo apt-get update

    • sudo apt-get install -y mssql-server @5

    • sudo /opt/mssql/bin/mssql-conf setup

    • systemctl status mssql-server

  • Install the SQL Server command-line tools
    • curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - 
    • sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list)"
    • sudo apt-get update
    • sudo apt-get install -y mssql-tools unixodbc-dev
    • echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
    • echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
    • source ~/.bashrc @6
  • Start working with SQLCMD
    • sqlcmd -S localhost -U SA

  • SQL Server Management Studio - remote

  • DBeaver – Database Management Studio
    • * Which Java version you have in your machine:
      java -version
    • sudo apt install <selected package which is last last version>
    • sudo apt-get -f install
    • Download Linux 64 bit (tar.gz archive) from dbeaver website
    • Unzip the file, and execute @7
  • Installing the SSIS Package on Ubuntu
    • curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

    • sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

    • sudo apt-get update

    • sudo apt-get install -y mssql-server-is

    • sudo /opt/ssis/bin/ssis-conf setup

    • export PATH=/opt/ssis/bin:$PATH

  • Install SQL Server Full-Text Search
    • sudo apt-get update

    • sudo apt-get install -y mssql-server-fts

  • Install SQL Server Agent on Linux
    • sudo apt-get update

    • sudo apt-get install mssql-server-agent

    • sudo systemctl restart mssql-server @8 final machine