Install Microsoft SQL Server on Ubuntu

Introduction

SQL Server now runs on Linux! As Microsoft CEO Satya Nadella said, "Microsoft Loves Linux", after both the built-in Linux subsystem of Windows 10 and the extensive use of Linux systems in Azure, Microsoft has launched a new SQL Server on Linux, enabling SQL Server to run cross-platform. The most popular databases support Linux, such as MySQL, Oracle Database, PostgreSQL, etc. MS SQL is naturally not far behind.

SQL Server on Linux uses the same database engine, the latest version is SQL Server vNext CTP 1.1.
The following takes the installation of SQL Server under Ubuntu 16.10 as an example to introduce the installation method of SQL Server on Linux (available for personal testing).

1. Import the public repository GPG key (the server may be unstable, just try a few more times if it fails)

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

2. Register Microsoft SQL Server Ubuntu repository

curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list

3. Install SQL Server

sudo apt-get update
sudo apt-get install -y mssql-server

4. Set the database SA user password and auto-start at boot

sudo /opt/mssql/bin/sqlservr-setup

5. Check whether the SQL Server service is started

systemctl status mssql-server

6. The database engine has been installed, and the corresponding SQL Server tools need to be installed to operate the database

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
sudo apt-get update
sudo apt-get install mssql-tools unixodbc-dev
ln -sfn /opt/mssql-tools/bin/sqlcmd-13.0.1.0 /usr/bin/sqlcmd 
ln -sfn /opt/mssql-tools/bin/bcp-13.0.1.0 /usr/bin/bcp

7. Test SQL Server

sqlcmd -S localhost -U SA

After entering the password you just set, enter the SQL Server command line tool mode and enter the following command to view all tables in the current database:

SELECT Name from sys.Databases;
GO

To connect to a remote SQL Server, just change "localhost" to the remote host IP and ensure that the SQL Server listening port (default listening TCP port 1433) is open, which can be connected in the SQL Server Management Studio tool on Windows SQL Server instances on Linux are used for visual management. Linux also has corresponding management tools, which will not be introduced here.

输入“QUIT”结束当前SQLCMD会话

The launch of SQL Server on Linux is naturally for .NET Core. Microsoft is constantly promoting the open source process of its products. Traditional ASP.NET websites can run cross-platform with only slight modifications, and any application can Efficient services can be provided through SQL Server. SQL Server not only provides traditional data storage services, but also has applications in enterprise data mining, data intelligence, and business analysis that other databases cannot meet. Opening SQL Server to Linux is undoubtedly a blockbuster for the industry. Through the elaboration of "Microsoft Loves Linux", Microsoft has demonstrated a future vision intertwined with data, intelligence and cloud computing.

The above is the detailed content of Install Microsoft SQL Server on Ubuntu. For more information, please follow other related articles on the PHP Chinese website!