Stacks572

Followers499

+ 1

Votes50

Microsoft SQL Server

Stacks10K

Followers6.9K

+ 1

Votes535

Add tool

Amazon RDS for Aurora vs Microsoft SQL Server: What are the differences?

Amazon RDS for Aurora: MySQL and PostgreSQL compatible relational database with several times better performance. Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability; Microsoft SQL Server: A relational database management system developed by Microsoft. Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

Amazon RDS for Aurora belongs to "SQL Database as a Service" category of the tech stack, while Microsoft SQL Server can be primarily classified under "Databases".

"MySQL compatibility " is the primary reason why developers consider Amazon RDS for Aurora over the competitors, whereas "Reliable and easy to use" was stated as the key factor in picking Microsoft SQL Server.

Stack Exchange, MIT, and PedidosYa are some of the popular companies that use Microsoft SQL Server, whereas Amazon RDS for Aurora is used by StackShare, GoGuardian, and Akoova. Microsoft SQL Server has a broader approval, being mentioned in 470 company stacks & 425 developers stacks; compared to Amazon RDS for Aurora, which is listed in 116 company stacks and 30 developer stacks.

Pros of Amazon Aurora

Pros of Microsoft SQL Server

13
MySQL compatibility
12
Better performance
10
Easy read scalability
7
Speed
6
Low latency read replica
1
High IOPS cost
1
Good cost performance

137
Reliable and easy to use
101
High performance
94
Great with .net
65
Works well with .net
56
Easy to maintain
21
Azure support
17
Always on
17
Full Index Support
10
Enterprise manager is fantastic
9
In-Memory OLTP Engine
2
Security is forefront
1
Columnstore indexes
1
Great documentation
1
Faster Than Oracle
1
Decent management tools
1
Easy to setup and configure
1
Docker Delivery

Sign up to add or upvote prosMake informed product decisions

Cons of Amazon Aurora

Cons of Microsoft SQL Server

0
Vendor locking

4
Expensive Licensing
2
Microsoft

Sign up to add or upvote consMake informed product decisions

What is Amazon Aurora?

Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

What companies use Amazon Aurora?

What companies use Microsoft SQL Server?

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Amazon Aurora?

What tools integrate with Microsoft SQL Server?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

How Codacy Analyzes 30 Billion Lines of Code Per Day

May 1 2019 at 12:25AM

Codacy

2119

Dubsmash: Scaling To 200 Million Users With 3 Engineers

Dec 14 2017 at 10:02AM

Dubsmash

+47

67470

The Stack That Helped Medium Scale To 2.6 Millennia Of Reading...

Oct 22 2015 at 8:05AM

Medium

+37

116

35513

What are some alternatives to Amazon Aurora and Microsoft SQL Server?

Amazon RDS

Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your Database Instance (DB Instance) via a single API call.

Google Cloud SQL

MySQL databases deployed in the cloud without a fuss. Google Cloud Platform provides you with powerful databases that run fast, don’t run out of space and give your application the redundant, reliable storage it needs.

Azure SQL Database

It is the intelligent, scalable, cloud database service that provides the broadest SQL Server engine compatibility and up to a 212% return on investment. It is a database service that can quickly and efficiently scale to meet demand, is automatically highly available, and supports a variety of third party software.

DigitalOcean Managed Databases

Build apps and store data in minutes with easy access to one or more databases and sleep better knowing your data is backed up and optimized.

Books

It is an immutable double-entry accounting database service. It supports many clients and businesses at global scale, leaning on Google Cloud Spanner and Google Kubernetes Engine to make that possible.

See all alternatives

Interest over time

How much does Amazon Aurora cost?

How much does Microsoft SQL Server cost?

Pricing unavailable

News about Amazon Aurora

How Minted scaled their online marketplace on Cyber Monday 2019 by migrating to AWS cloud and Amazon Aurora

(aws.amazon.com)

Aug 3, 2020

Recap of Amazon RDS and Aurora features launched in 2019

(aws.amazon.com)

Apr 6, 2020