Azure cloud databases
While an Azure data lake stores raw data, an Azure database usually stores formatted data. Azure offers cloud database services categorized into relational databases and NoSQL databases.
Azure cloud relational databases
Like AWS and GCP, Azure offers three options for cloud relational database deployment and usage:
- Azure SQL virtual machines: SQL Server built on Azure virtual machines. This is an Infrastructure-as-a-Service (IaaS) cloud service and thus you will have control of the database edition, version, and size. You will also be fully responsible for managing the virtual machine, including patching and other configuration management. More information is available at https://azure.microsoft.com/en-us/products/virtual-machines/sql-server.
- Azure SQL managed instances: This is the best for migrating on-premises SQL databases to the cloud. It serves the purpose of migrating many apps from on-premises to a fully managed Platform-as-a-Service...
