Relational Databases

Amazon RDS vs Azure SQL Database

Compare Amazon RDS and Azure SQL Database side-by-side. See feature differences and pricing in the Relational Databases category.

Amazon RDS

by Amazon

No reviews yet

Pricing: Usage-based, per instance-hour. MySQL or PostgreSQL on db.t4g.micro in us-east-1: $0.016/hr On-Demand, $0.0116/hr 1-year Reserved. Free Tier for up to 12 months.

Amazon RDS is AWS's managed relational database service for MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, Db2 and Aurora, billed by the instance-hour.

17 /18 features Full profile

Azure SQL Database

by Microsoft

No reviews yet

Pricing: Free offer for up to 10 databases; Hyperscale from $266.684 a month for 2 vCores, pay as you go; other tiers billed by the hour, the vCore-second or the day.

Azure SQL Database is Microsoft's relational cloud database service for Transact-SQL apps, run as a platform service with vCore, serverless and DTU options.

13 /18 features Full profile

Feature Comparison

Relational Databases features side-by-side

Feature	Amazon RDS 17/18 features	Azure SQL Database 13/18 features
ACID transactions with row-level locking Multi-statement transactions commit or roll back atomically while concurrent writers lock individual rows, not whole tables.	Yes	Yes
Declarative table partitioning Large tables split by range, list or hash key, with the planner pruning partitions that a query cannot touch.	Yes	Yes
Native JSON column type with indexing A binary JSON type that can be queried by path and indexed, rather than JSON stored as plain text.	Yes	Yes
Built-in full-text search indexes Text columns indexed for ranked keyword and phrase search without deploying a separate search engine.	Yes	Yes
Streaming physical replication to standbys Hot standby replicas receive the write-ahead log continuously and can serve read-only queries.	Yes	Yes
Logical replication of selected tables Row changes published per table or schema to subscribers, including subscribers on a different major version.	Yes	No
Synchronous multi-replica commit A write is acknowledged only after one or more standbys confirm it, so a failover loses no committed data.	Yes	Yes
Automatic failover to a standby The engine or its bundled cluster manager detects a failed primary and promotes a replica without an operator.	Yes	Yes
Point-in-time recovery from archived logs Restore the database to any moment between backups by replaying archived transaction logs.	Yes	Yes
Online schema changes without table locks Columns can be added and indexes rebuilt while the table stays readable and writable.	No	Yes
Columnstore indexes for analytics Column-oriented storage on selected tables or indexes to speed aggregate queries over large row counts.	Yes	Yes
Row-level security policies Per-row read and write predicates that the engine enforces for each database role.	Yes	Yes
Transparent data encryption at rest Data files and logs encrypted on disk by the engine itself, with keys held outside the data directory.	Yes	Yes
Stored procedures in multiple languages Server-side procedures written in SQL plus at least one general-purpose language such as Python or Java.	Yes	No
Extension or plugin architecture Third-party extensions load new data types, index methods or functions into the engine without a fork.	Yes	No
Query store or plan history Execution plans and their statistics retained over time so regressions can be found and a plan pinned.	Yes	Yes
In-place major version upgrade tooling A supported tool upgrades the data directory across major versions without a full dump and reload.	Yes	No
Open source core under a permissive license The engine's source is public and the community edition can run in production with no license fee.	Yes	No
Overall Rating	No reviews yet	No reviews yet

Amazon RDS 17/18 features

ACID transactions with row-level locking: Yes
Declarative table partitioning: Yes
Native JSON column type with indexing: Yes
Built-in full-text search indexes: Yes
Streaming physical replication to standbys: Yes
Logical replication of selected tables: Yes
Synchronous multi-replica commit: Yes
Automatic failover to a standby: Yes
Point-in-time recovery from archived logs: Yes
Online schema changes without table locks: No
Columnstore indexes for analytics: Yes
Row-level security policies: Yes
Transparent data encryption at rest: Yes
Stored procedures in multiple languages: Yes
Extension or plugin architecture: Yes
Query store or plan history: Yes
In-place major version upgrade tooling: Yes
Open source core under a permissive license: Yes

No reviews yet

Azure SQL Database 13/18 features

ACID transactions with row-level locking: Yes
Declarative table partitioning: Yes
Native JSON column type with indexing: Yes
Built-in full-text search indexes: Yes
Streaming physical replication to standbys: Yes
Logical replication of selected tables: No
Synchronous multi-replica commit: Yes
Automatic failover to a standby: Yes
Point-in-time recovery from archived logs: Yes
Online schema changes without table locks: Yes
Columnstore indexes for analytics: Yes
Row-level security policies: Yes
Transparent data encryption at rest: Yes
Stored procedures in multiple languages: No
Extension or plugin architecture: No
Query store or plan history: Yes
In-place major version upgrade tooling: No
Open source core under a permissive license: No

No reviews yet

Pricing

Amazon RDS

Usage-based, per instance-hour. MySQL or PostgreSQL on db.t4g.micro in us-east-1: $0.016/hr On-Demand, $0.0116/hr 1-year Reserved. Free Tier for up to 12 months.

See all plans

Azure SQL Database

Free offer for up to 10 databases; Hyperscale from $266.684 a month for 2 vCores, pay as you go; other tiers billed by the hour, the vCore-second or the day.

See all plans

Explore Each Product

Amazon RDS Read reviews, features & pricing

Azure SQL Database Read reviews, features & pricing

Looking for more options?

Browse all Relational Databases