CODEWITHSUNDEEP
sql-serverazure-sql-database
Moiz Khan
Moiz Khan

Reputation: 21

Difference between SQL Database and SQL Server in Microsoft Azure Portal

I see 2 Azure offering SQL Database and SQL Server on Azure Portal, whats the difference ? I understand SQL Database is SaaS and SQL Server is PaaS.

enter image description here

Upvotes: 2

Views: 11315

Answers (2)

Etteplan_genius_at_work
Etteplan_genius_at_work

Reputation: 1

It does not have to be on Windows server and T-SQL language differences. That's most of it. See the Microsoft docs for further information.

https://sqlstudies.com/2016/08/09/azure-whats-the-difference-between-sql-database-and-sql-server/

Upvotes: 0

SQLmojoe
SQLmojoe

Reputation: 2043

The SQL server (lower case s for server) here is a strong container for 1 or more databases which can be of multiple types. Today you can have Azure SQL Database, SQL Data Warehouse and SQL Stretch database all in the same logical SQL server. The server is the public endpoint you connect to. Other objects like logins are hosted there also.

SQL Server (upper case S for Server) is the "box" product that can be hosted on your own machines or in Azure VMs as an IaaS solution. You can in most cases think of an Azure SQL server conceptually as very similar to the box SQL Server instance but actual underlying setup is quite different.

Upvotes: 8

Related Questions