Shulou(Shulou.com)06/02 Report--

In this article, the editor introduces in detail "how to install SQL Server on Ubuntu", the content is detailed, the steps are clear, and the details are handled properly. I hope this article "how to install SQL Server on Ubuntu" can help you solve your doubts.

SQL Server is a relational database management system developed by Microsoft Company, which has the advantages of easy to use, good scalability and high degree of integration of related software.

The following is to install SQL Server under Ubuntu 16.10 as an example to introduce the installation method of SQL Server on Linux (self-testing is available).

1. Import the public repository GPG key (the server may be unstable. If you fail, you can try several times more)

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

2. Register the 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 updatesudo apt-get install-y mssql-server

4. Set the database SA user password and boot automatically.

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.listsudo apt-get updatesudo apt-get install mssql-tools unixodbc-devln-sfn / opt/mssql-tools/bin/sqlcmd-13.0.1.0 / usr/bin/sqlcmdln-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 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, simply modify "localhost" to the remote host IP and make sure that the SQL Server listening port (default listening TCP port 1433) is open. You can use the SQL Server Management Studio tool on Windows to connect to the SQL Server instance on Linux for visual management. Linux also has corresponding management tools, which are not introduced here.

Enter "QUIT" to end the current SQLCMD session

The launch of SQL Server on Linux is naturally for the .NET Core service, Microsoft is constantly promoting the open source process of its products, the traditional ASP.NET website can run across platforms with only a little modification, and any application can provide efficient services through SQL Server. SQL Server not only provides traditional data storage services, but also can not be satisfied by other databases in enterprise data mining, data intelligence and business analysis. Opening SQL Server to Linux is undoubtedly a blockbuster for the industry. Through the exposition of "Microsoft Loves Linux", Microsoft presents a vision of the future that is intertwined with data, intelligence and cloud computing.

Read here, this "how to install SQL Server on Ubuntu" article has been introduced, want to master the knowledge of this article also need to practice and use to understand, if you want to know more about the article, welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.