Does Azure SQL use SQL Server?

Question

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.

Is Azure SQL Database SQL Server?

Azure SQL Database is a fully managed database service, which means that Microsoft operates SQL Server for you, and ensures its availability and performance. SQL Database also includes innovative features to enhance your business continuity, such as built-in high availability.

Is Azure SQL different from SQL Server?

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 Server does Azure use?

ProductDatabase Engine versionCompatibility LevelSQL Server 201915150Azure SQL Database12150Azure SQL Database Managed Instance12150SQL Server 201714140

Expert · Answer