Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL Server 2017 on LINUX | How to install SQL Operations Studio(SOS) on LINUX(Ubuntu)

First lets us understand What is Ubuntu and SQL operations studio? Ubuntu is a free and open source operating system and Linux distribution based on Debian.
Ref – https://en.wikipedia.org/wiki/Ubuntu_(operating_system)

SQL Operations Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. For more details please refer- https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/

In this post we shall check out the how to install SQL Operations Studio on Ubuntu.

Steps-

1. Open url – https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017

2. Go to – Get SQL Operations Studio (preview) for Linux -> Go to tar.gz Installation or find tar.gz Installation. Following code will be there.

3. Download SQL Operations Studio (preview) for Linux by using the tar.gz archive.

Download the SOS for Ubuntu

4.1 Go to terminal and execute the following command.

	--

	cd ~ 	

	--

4.2 Go to terminal and execute the following commands one by one.

	--

	cd ~ 
	cp ~/Downloads/sqlops-linux-<version string>.tar.gz ~ 
	tar -xvf ~/sqlops-linux-<version string>.tar.gz 
	echo 'export PATH="$PATH:~/sqlops-linux-x64"' >> ~/.bashrc
	source ~/.bashrc 

	--

4.3 Launch SQL Operations Studio using sqlops command via Terminal.

    Server Name: localhost
    Authentication Type: SQL Login
    User name: sa
    Password: sa password
    Database Name: default
    Server Group: default

Sample Script

--

CREATE TABLE Test
(
    Id INT
)
GO

INSERT INTO Test VALUES (1),(2)
GO

SELECT * FROM Test
GO

--

References-

1 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download
2 https://go.microsoft.com/fwlink/?linkid=875602
3 https://msbiskills.com/2018/01/19/2017-new-data-management-tool-for-sql-server-sql-operations-studio/
4 https://docs.microsoft.com/en-us/sql/sql-operations-studio/download?view=sql-server-2017

Other SQL SERVER on Linux related articles

1 https://msbiskills.com/2018/07/11/sql-server-2017-on-linux-faqs-microsoft/

Enjoy.

Thank you for reading.!!!

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Performance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com