SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu

This blog has been updated. Kindly follow the link

Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In my previous posts of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install Ubuntu Server on the created virtual machine and how to install SQL Server on the Ubuntu Server. Now, we will walkthough a step by step SQL Server Tools installation process.

The MSSQL-Tools package contains Command Line utilities & Bulk Import-Export utilities. The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The BCP utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. Installing SQL Server Tools will also install the Microsoft ODBC driver and all its dependencies by default.

Step-by-Step process to install SQL Server Tools;

  • If you are not logged on to the system as superuser mode, kindly switch to superuser mode

02switchrootuser

  • Register the Microsoft Ubuntu repository

Syntax: curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

02ubunturepository

  • You need to run the below script to get all the latest updates from Ubuntu & Microsoft online servers

Syntax: sudo apt-get update

03-get-update

  • Install the SQL Server Tools – During the installation of the tool, it will prompt you to accept the license terms for MSSQL-Tools and Microsoft ODBC driver

Syntax: sudo apt-get install mssql-tools

MSSQL-TOOLS license terms message box prompt – click on “Yes”04
Microsoft ODBC driver license terms message box prompt – Click on “Yes”05
You will not see any message that says the tools have been installed successfully but do get installed.06toolinstall
  • Verify the connectivity of SQL Server on Linux machine using command line tool now

Syntax: sqlcmd -H <hostname> -U <username> -P <password>

07conntosqlserver

Wow! you have completed a successful installation of SQL Server on Linux on Windows hyper-v and learned a lot.  This was my last post of ‘SQL Server on Linux Installation’ series. Please do share you experience!

 

2 thoughts on “SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu

  • ananth

    sir i watched your video about installation of sql server on Linux it was awesome but am not seen any link about to access shared folder could you please provide the web link to access the Linux shared folder in windows for SQL server backups purpose

    Reply

Leave a comment

Your email address will not be published. Required fields are marked *