SQL SERVER for Linux first experience

Today Hollow, the Ubuntu17.04 is installed on the SQL SERVER 2017 experience, overall is good.

Installing SQL SERVER 2017 on Ubuntu is also convenient, with just a few commands:

Curl https:///packages.microsoft.com/keys/microsoft.ascsudo"$ (Curl HTTPS ://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list)"sudo apt-get update  sudoinstall -y mssql-serversudo /opt/mssql/bin/mssql-conf setup

Currently, there are 7 versions available for installing SQL SERVER 2017, and I chose the Free Express Edition. After executing the above command, you will be prompted to have a 175-day trial period, if you choose the free version, you can always use, regardless of this message.

After the installation is complete, you can use the command

Systemctl Status Mssql-server

To view the health status of SQL SERVER 2017

Microsoft provided a command-line tool for interacting with the database, but I chose JetBrains (the company's masterpiece, the famous ReSharper) to provide good support for a variety of databases, with the Datagrip at the beginning of this article.

JetBrains's products are free for students, MVP, open source project developers. Finally, Amway a jetbrains product, Rider, a cross-platform. NET development tools that can effectively reduce the pain index of writing. NET core programs on Linux.

Reference documents

Install SQL Server and create a database on Ubuntu

Copyright notice

This article is the author original, the copyright belongs to the author Snow Feihong all. Reproduced must retain the integrity of the article, and in the page marked the location of the original link.

If you have questions, please email and contact the author.

SQL SERVER for Linux first experience