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

This article will explain in detail the usefulness of the public preview version of SQL Server under Linux. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Microsoft has released a public preview of its next version of the SQL Server database, which supports both Linux and Windows.

In March of this year, Microsoft released an internal preview of SQL Server for Linux. Meanwhile, Microsoft officials say SQL Server for Linux is a subset of the SQL Server for Windows version and will run on Ubuntu or as a Docker image (later added that internal previews also support Red Hat's RHEL). The company officially said that the SQL Server purchased by users would be able to be used on Windows servers or Linux, and said shortly afterwards that the version of SQL Server for Linux and for Windows were actually the same.

However, today (November 16, US time), Microsoft positioned SQL Server Next as a product that can run on both Linux and Windows.

Microsoft officials say that SQL Server Next running on Linux and running on Windows is based on the same code base. "there are platform differences in some features, such as the file path on Linux is different from Windows," but these are not two completely different products. SQL Server Next running on Linux has "all the major features of a relational database engine", including in-heap online transaction processing (OLTP), in-heap column storage, transparent data encryption, full-process encryption, row-level security, and so on.

The public preview version of SQL Server for Linux, which supports Ubuntu, Red Hat's RHEL, and SUSE's SLES, will soon be available in Azure virtual machines and on Docker Hub. However, Microsoft still said that the official version of SQL Server, which supports Linux and Windows, will not be released until the middle of next year.

The public preview version of SQL Server under Linux can be downloaded from Microsoft's SQL Server on Linux website.

It is well known that companies using open source software will not replace their free and powerful MariaDB or MySQL database solutions with SQL Server, but Microsoft's SQL Server promises to support Docker containers and allows the choice of data types and development languages, and for some scenarios, using SQL Server can save costs, improve performance, and increase flexibility. After the release of the internal preview version in March, Microsoft announced that more than 8000 companies had signed up to try SQL Server for Linux within * weeks, and more than half of the Fortune 500 companies took part in the trial.

This is the end of the article on "what is the use of the public preview version of SQL Server under Linux". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.