Edit

Share via


Relational database technologies on Azure and AWS

This article helps map familiar AWS database services to the equivalent offerings from Microsoft.

Amazon RDS and Azure relational database services

Azure provides several different relational database services that are the equivalent of AWS' Relational Database Service (Amazon RDS). These include:

Other database engines such as SQL Server, Oracle, and MySQL can be deployed using Azure VM instances.

Costs for Amazon RDS are determined by the amount of hardware resources that your instance uses, like CPU, RAM, storage, and network bandwidth. In the Azure database services, cost depends on your database size, concurrent connections, and throughput levels. In Microsoft Fabric, the cost is based on the capacity SKU purchased, which entitles you to a set of Capacity Units (CUs). These CUs are shared across all Fabric workloads, such as SQL Database in Microsoft Fabric.

See also

Analytics and big data

Azure provides a package of products and services designed to capture, organize, analyze, and visualize large amounts of data consisting of the following services:

  • Azure HDInsight: managed Apache distribution that includes Hadoop, Spark, Storm, or HBase.

  • Azure Data Factory: provides data orchestration and data pipeline functionality.

  • Microsoft Fabric: a unified data platform that accelerates time to value across data engineering, data warehouse, lakehouse, real-time analytics, data science and business intelligence.

  • Azure Databricks: a unified analytics platform for data analysts, data engineers, data scientists, and machine learning engineers.

  • Azure Data Lake Storage: a modern data lake solution in Azure that combines the scalability and durability of Blob Storage with hierarchical namespace support. It is optimized for big data analytics and integrates seamlessly with services like Azure Databricks, and Microsoft Fabric.

  • Azure Machine Learning: used to build and apply predictive analytics on data.

  • Azure Stream Analytics: real-time data analysis.

  • Power BI: a business analytics service that provides the capabilities to create rich interactive data visualizations.

Service comparison

Type AWS Service Azure Service Description
Relational database Amazon RDS Azure SQL Database

Azure Database for MySQL

Azure Database for PostgreSQL
Managed relational database services in which resiliency, scale and maintenance are primarily handled by the Azure platform.
Serverless relational database Amazon Aurora Serverless Azure SQL Database serverless

SQL Database in Microsoft Fabric
Database offering that automatically scales compute based on the workload demand. You're billed per second for the actual compute used.
Data Warehouse Amazon Redshift Warehouse in Microsoft Fabric Warehouse in Microsoft Fabric is a lake-centric, distributed relational data warehouse that supports scalable SQL-based analytics and integrates tightly with Fabric workloads for unified analytics experience.
NoSQL DynamoDB (Key-Value)

SimpleDB

Amazon DocumentDB (Document)

Amazon Neptune (Graph)
Azure Cosmos DB

Cosmos DB in Microsoft Fabric
Azure Cosmos DB is a globally distributed, multi-model database that natively supports multiple data models including key-value pairs, documents, graphs, and columnar. Cosmos DB in Microsoft Fabric uses the same architecture as Azure Cosmos DB for NoSQL but is tightly integrated into the Microsoft Fabric platform.
Caching ElastiCache

Amazon MemoryDB for Redis
Azure Cache for Redis An in-memory–based, distributed caching service that provides a high-performance store that's typically used to offload nontransactional work from a database.
Database migration Database Migration Service Azure Database Migration Service

Microsoft Fabric Migration Assistant for Data Warehouse
A service that executes the migration of database schema and data from one database format to a specific database technology in the cloud.

Contributors

This article is maintained by Microsoft. It was originally written by the following contributors.

Principal author:

Other contributor:

To see non-public LinkedIn profiles, sign in to LinkedIn.

Additional resources