3

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

Improve this question
1
  • 5
    The SQL Server is the logical container for one or more SQL Databases Commented Mar 31, 2016 at 3:33

2 Answers 2

Reset to default
8

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

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/

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.