Try our new research platform with insights from 80,000+ expert users

Amazon Aurora vs SQL Server comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Amazon Aurora
Ranking in Relational Databases Tools
9th
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
15
Ranking in other categories
No ranking in other categories
SQL Server
Ranking in Relational Databases Tools
1st
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
267
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the Relational Databases Tools category, the mindshare of Amazon Aurora is 3.4%, down from 4.3% compared to the previous year. The mindshare of SQL Server is 20.1%, down from 23.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Rajitha Jatothu - PeerSpot reviewer
Achieve high performance with fault-tolerant and highly available database management
Aurora is a key pillar for us, offering performance and availability. It is faster than RDS and supports multi-region clusters and scalability. One feature we value is Aurora's ability to provide a reader endpoint, allowing applications to connect without tracking replicas. It supports auto-scaling and offers several options for monitoring and optimizing database performance. Aurora's fault tolerance and ability to handle multiple replicas contribute to its reliability and high performance.
Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature is that the maintainability is offloaded to the service provider. I don't have to maintain a database or do any administrative tasks, which comes in handy."
"The provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"Aurora's features that I find the most beneficial include its database backup strategy, performance options, and input-output operations."
"The most valuable feature is the ability to do multiple-read and single-write. These are the kinds of features that we were interested in, and Aurora takes care of that natively."
"One of the most valuable features is storage scaling."
"Aurora's compatibility with MySQL or PostgreSQL benefited our database management. The migration from on-premise MySQL to Aurora was similar, so we didn't need to change our source code."
"Amazon Aurora stands out for its ease of use in a managed environment, inbuilt security, continuous backups, numerous read replicas, multi-region automated replication, and seamless integration with other AWS services."
"The most valuable feature of the solution, compared to other RDBMS solutions, such as Oracle MySQL or IBM DB2, it is more user-friendly and has backward compatibility. For example, if you have an application that requires an old version of SQL Server and you have the latest version of the license, you are able to install and use it in backward compatibility mode. They keep supporting the existing legacy application."
"We like business integration, database, and analysis."
"SQL Server is essentially the backbone of every microservice. From a developer's perspective, it is the backbone of all microservices. The tool enables data retrieval, set data, and essential operations, ensuring the smooth functioning of applications. In essence, it is the integral part that keeps applications operational."
"The features that we have found the most valuable are reliability, availability perspective, and current scalability."
"The product has very good online documentation that can be used for troubleshooting."
"It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based. It is a very stable product, and it has got backup and recovery tools."
"The ability to see tables, reviews, and custom script options is good."
"The product’s most valuable features are flexibility and scalability."
 

Cons

"One of the most valuable features is storage scaling."
"I would like to see performance insights on the database based on the queries. Currently, we use SolarWinds as the monitoring tool. I would like to leverage SolarWinds’ performance insights in AWS services. SolarWinds gives larger insights when we run performance issues."
"It is a bit costly. The features are quite good, and I wouldn't say it requires any technical improvements. But from a cost perspective, some clients wouldn't go for Aurora because of that."
"There is improvement needed to have more developer focus. Additionally, it would be helpful to have a stand-alone solution outside of Amazon. Amazon has a tendency to favor developing web-based clients, which may not always provide the fastest or most responsive solution as desired."
"In Oracle, tools like Veridata allow for comparing databases and certifying data accuracy, even offering repair capabilities, which are missing in Aurora. There should be a similar comparison tool in Aurora."
"I would like to see more AI-related features in future releases."
"The pricing could improve. It should be reduced."
"It would have been helpful if they had provided some benchmarking numbers."
"SQL Server backups could be better."
"One thing I don't like about SQL Server is the way they've set up security with users and groups. It just doesn't seem that intuitive to me. Adding some more explanatory information might help some."
"SQL Server could improve by enhancing the integration abilities, adding more inbuilt data security features, and simplifying the maintenance."
"The security features of the solution could be better."
"Right now we don't get much technical support from Microsoft"
"Currently, I do not face any difficulties with SQL Server as all options and documentations are available."
"Query optimitzer could be simplified."
"There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product."
 

Pricing and Cost Advice

"It is quite expensive."
"The price could be lower compared to its competitors."
"I would rate the pricing a six out of ten, with ten being expensive."
"There is no need to buy a license for the product. We can pay as per the use case."
"It is an expensive solution."
"The tool’s pricing depends on the instance type. For cost optimization purposes, we use the result instance category."
"The cost associated with SQL Servers is on the higher side."
"We are on a monthly subscription and the price could improve. However, the price has worked out well in some deployments. The problem is you never know what kind of services been installed and you have to be in touch with many people, such as which servers are active or which are not. I did face a couple of issues in terms of subscriptions and the pricing model. They have improved over time."
"Pricing for this product is very reasonable."
"Synapse is a bit costly. If I compare it with different databases, I think it's a reasonable price"
"​We are a Microsoft shop, so we use Active Directory. That integrates well with this product, but we did look at Oracle. We also looked at IBM. This was the best price point for us for what we were getting.​"
"The product's price is reasonable."
"Our customers do pay license fees for the MS SQL Server but the Rabbit is free, as it is open-source software."
"The price could be better. Aside from the basic features, if you need any additional features that can be extended, for example, if you want to connect with the heterogeneous databases, they are being managed as separate services and not included in the package. If you manage a database in Azure, it's not providing SFS and reporting services. However, on-premises, if you purchase the SQL Server license, it includes SFIS and SFRS services. If you take Postgre SQL and MySQL, they provide almost all the same features even though they are both open source databases."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
838,640 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
27%
Computer Software Company
15%
Government
6%
Manufacturing Company
5%
Educational Organization
52%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Amazon Aurora?
Aurora's compatibility with MySQL or PostgreSQL benefited our database management. The migration from on-premise MySQL to Aurora was similar, so we didn't need to change our source code.
What is your experience regarding pricing and costs for Amazon Aurora?
AWS is costlier than self-managed solutions, but this includes the managed service experience. Their pricing is fair and reflects the managed service and additional features AWS offers.
What needs improvement with Amazon Aurora?
AWS RDS doesn't provide an option to apply one-off patches, which can be critical for business due to unexpected product bugs. While self-managed systems allow immediate patch application, RDS has ...
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

No data available
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

Dow Jones, Arizona State University, Verizon, Capital One, United Nations, Nielsen, Autodesk, Fanduel
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about Amazon Aurora vs. SQL Server and other solutions. Updated: January 2025.
838,640 professionals have used our research since 2012.