Is Azure SQL the same as SQL Server?

Question

Since Azure SQL is based on SQL Server, they share many similarities in functionality and compatibility. But that doesn't mean they are the same. In fact, contrary to what many think, Azure SQL is not exactly the cloud version of SQL Server because there are many fundamental differences between the two. 10 сент. 2018 г.

Is Azure SQL Database SQL Server?

Azure SQL Database is based on the latest stable version of the Microsoft SQL Server database engine. You can use advanced query processing features, such as high-performance in-memory technologies and intelligent query processing.

What is the difference between SQL Server and Azure?

Azure SQL Database offers Database-as-a-service (DBaaS-PaaS). With SQL Database, you don't have access to the machines that host your databases. In contrast, Azure Virtual Machine offers Infrastructure-as-a-service (IaaS). Running SQL Server on an Azure VM is similar to running SQL Server in a On-Premise datacenter.

Is Azure SQL compatible with SQL Server?

Azure fully supports running any edition of SQL Server on IaaS (VM). Combined with 'Always On' availability groups you will be able to achieve full compatibility with legacy on-premises SQL installs.

What version of SQL is Azure SQL?

VersionStatusReleaseversion 1 (latest)ReleasedJuly 12, 2019version 06-01-2016SunsetJanuary 6, 2016

Expert · Answer