Amazon DynamoDB vs Microsoft SQL Server
Amazon DynamoDB
aws.amazon.comMicrosoft SQL Server
microsoft.comSide by side
| Figure | Amazon DynamoDB | Microsoft SQL Server |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | Yes | Yes |
| macOS | Yes | — |
| Linux | Yes | Yes |
| iOS | Yes | — |
| Android | Yes | — |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 4 | 20 |
| Spec score · Transaction Data Store Software | 9.0 (#2) | 8.0 (#20) |
| Spec score · Database Software | 8.9 (#11) | 8.5 (#24) |
| Free plan | Yes | Yes |
| Integrations | The feature page lists integrations with AWS services; it describes AWS KMS encryption, IAM access control, and VPC endpoints with AWS PrivateLink. | SQL Server 2025 integrates with LangChain, Semantic Kernel, Entity Framework Core, Microsoft Azure, and Microsoft Fabric. |
| Security | Customer data is encrypted in transit and at rest by default, and access can be controlled with IAM policies down to specific items and attributes. | Microsoft's SQL Server security guidance covers platform and network security, permissions, encryption, and secure connections. |
Plans
Amazon DynamoDB
- Free tierFree
- On-demand capacityPrice not published
- Provisioned capacityPrice not published
- DynamoDB Free TierFree
Microsoft SQL Server
- Standard per corePriced on request
- Standard per corePrice not published
- Standard serverPriced on request
- Standard serverPrice not published
- Standard CALPriced on request
- Standard CALPrice not published
- Enterprise pay-as-you-go$274 a month
- Developer – Standard & EnterpriseFree
- ExpressFree
- Standard pay-as-you-go$73 a month
In their own words
Amazon DynamoDB
Amazon DynamoDB is a serverless, managed NoSQL database for applications that need single-digit millisecond performance at any scale, according to AWS. Users do not provision or patch database servers, and tables can scale automatically, including to zero in on-demand mode. Primary keys and global or local secondary indexes provide ways to query data. Global tables support multi-Region, multi-active operation; AWS says they are designed for up to 99.999% availability. The database also supports native vector search for similarity searches and agent memory use cases. Data is encrypted in transit and at rest by default, and IAM policies can restrict access to specific items and attributes. Point-in-time recovery provides continuous, per-second backups and restoration within a configured period of 1 to 35 days. A free tier is listed with 25 WCUs, 25 RCUs, and 25 GB of storage per Region and payer account, among other limits. On-demand capacity is billed per request consumed; provisioned capacity is billed for specified capacity even if usage is lower.
Microsoft SQL Server
Microsoft SQL Server is a database platform for storing, processing, and securing data, offered with both deployment models and a free plan. Its Database Engine includes replication, full-text search, relational, XML, and JSON data management, as well as Python and R machine-learning services. Integration Services provides graphical tools and programmable objects for moving and transforming data, while PolyBase can query Azure Storage, S3, and ODBC sources. SQL Server 2025 adds vector search, vector embedding generation, text chunking, and DiskANN vector indexing, and integrates with LangChain, Semantic Kernel, Entity Framework Core, Microsoft Azure, and Microsoft Fabric. Microsoft provides downloads for Windows and Linux and a SQL Server container image for Docker. Express is a free entry-level edition for learning and desktop or small server applications; its single Database Engine instance is limited to the lesser of one socket or four cores. Developer editions provide Enterprise or Standard functionality for development and testing, not production. SQL Server 2025 does not support SUSE Linux Enterprise Server.