Tutorial on installing SQL Server in Ubuntu, ubuntusql

Tutorial on installing SQL Server in Ubuntu, ubuntusql

Microsoft just announced a Public Preview of the next generation of SQL Server, and Canonical officially announced that this preview version can be used in Ubuntu. Whether deployed internally or on the cloud, SQL Server on Ubuntu provides developers and organizations with more freedom to choose from. The development languages and data types allowed by SQL Server have become one of the most innovative and flexible platforms available to the market.

In the next generation of SQL Server, Microsoft provides more powerful functions for SQL Server on Linux and Windows platforms, including support for Docker containers. In addition, SQL Server on Ubuntu can significantly reduce costs, improve performance, and easily expand and deploy additional storage and computing resources without adding more hardware.

Cost: organizations can leverage the elasticity and low-cost resources of the Microsoft Azure platform to bring about a lot of cost benefits. resources can be allocated on demand and reduced when the platform is not used-non-active resources are not charged.
Performance: in the cloud, resources that manage database workloads are optimized as needed. By using a process container like Docker and a service model solution like Canonical Juju, organizations can improve their workload performance, and improve the speed and efficiency of deploying data-centric solutions.
Scalability: the next generation of SQL Server promises to allow DBAs to build large-scale Microsoft Azure-based databases without adding more hardware. Through support for Linux containers (such as Docker processes or Canonical LXD container), organizations can surpass traditional efficiency, the combination of Canonical and Microsoft on Ubuntu, SQL Server, container, and Azure brings a very consistent Linux cloud experience.

Earlier this year, Microsoft announced the SQL Server on Linux program. Canonical also continued to work with Microsoft to bring the best Linux system to the Microsoft platform. "Microsoft and Canonical continue to build bridges between the Windows and Linux worlds," said Dustin Kirkland, Canonical technical director. SQL Server on Ubuntu is another example of this trend .」

Install SQL Server on Ubuntu

The SQL Server on Linux version released by Microsoft is SQL Server vNext CTP1, which supports Red Hat Enterprise Linux 7.2b and Ubuntu 16.04 systems (SUSE Linux Enterprise Server v12 SP2 will be coming soon ), the following describes how to install and deploy Ubuntu 16.04.

Copy codeThe Code is as follows: # import the GPG key of the public repository
Https://packages.microsoft.com/keys/microsoft.asc | apt-key add-
# Register a Microsoft SQL Server Ubuntu Repository
Curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list>/etc/apt/sources. list. d/mssql-server.list

# Install SQL Server on Linuxsudo apt updatesudo apt install-y mssql-server

After the software package is installed, run the configuration script and follow the prompts:

sudo /opt/mssql/bin/sqlservr-setup

Enter your sa account password, and the prompt is:

After the configuration is complete, verify that the service is running:

systemctl status mssql-server