Number | Base of difference | Azure SQL Database | SQL Server |
1 | Basic definition | It is a cloud computing database service platform and this is being given by Microsoft Azure. | It is a relational database management system which is developed by Microsoft which begin with an assortment of add-on services. |
2 | CLR Support | This will not support the Common Language Runtime(CLR). | This will support the CLR. |
3 | Storage | This will have a storage of up to 16 TB. | This will has storage upto 256 TB. |
4 | Process | This is an automatic process. | When we say about the SQL Server this will not have the automatic process. |
5 | Services | It has software multitenancy and authorizes all tenants to utilize its physical entities in real-time. | It is only the entity on the server, whereas one database can host various databases from different databases. |
6 | Logs and transaction | When we say about the Azure SQL Database this can automatically backup the database and transaction logs periodically. | When we say about the SQL Server it can copy data record from the SQL Server database from its transaction log. |
7 | Database size | When we say about the Azure SQL Database here database size always depends on the underlying service tier. | When we say about the SQL Server here max size of the database is constrained by the size of the VM. |
8 | Availability
| The availability of it is 99.995, and it is a pledge. | The availability of it is 99.99 |
| | | . |