We compared SQL Server and Amazon Aurora based on our user's reviews in several parameters.
In summary, SQL Server is praised for its robustness, reliability, security, and user-friendly interface, with reasonable pricing and satisfactory ROI. On the other hand, Amazon Aurora stands out for its scalability, performance, and user-friendly interface, with varying user experiences in terms of pricing and setup. Users highlight the need for enhancements in both products, such as performance optimization and improved usability.
Features: SQL Server stands out for its robustness, reliable handling of large data, seamless integration with Microsoft products, comprehensive security measures, and user-friendly graphical interface. In comparison, Amazon Aurora excels in seamless scalability, easy-to-use interface, and impressive speed, allowing for efficient and smooth operations.
Pricing and ROI: The setup cost for SQL Server has been praised as straightforward and efficient, with flexible licensing options. In contrast, the experience with pricing, setup cost, and licensing of Amazon Aurora is more varied. While some find the pricing competitive and appreciate the lack of upfront setup costs, others find the licensing terms complicated. Individual perspectives and requirements play a significant role in determining the experience with pricing, setup cost, and licensing., SQL Server offers significant improvements in efficiency, data management, and cost savings, with seamless integration, robust security, and superior performance. On the other hand, Amazon Aurora provides a valuable ROI for its users.
Room for Improvement: The SQL Server product could benefit from improvements in usability, performance optimization, compatibility with other platforms, handling of complex queries, security features, and efficient handling of large datasets. On the other hand, Amazon Aurora could improve in terms of performance, scalability, backup and restoration processes, user interface usability, and pricing structure.
Deployment and customer support: The reviews indicate that the time required for establishing a new tech solution with SQL Server can range from a week to three months, with deployment and setup phases possibly being separate. The feedback for Amazon Aurora also varies, with deployment taking anywhere from a week to three months, and setup being completed in the same timeframe or an additional week. Considering the context is essential for understanding the duration of these phases., Customers have praised the reliability and efficiency of SQL Server's customer service, while Amazon Aurora's support team has been commended for their prompt assistance and knowledge. Differences lie in specific areas of support provided.
The summary above is based on 42 interviews we conducted recently with SQL Server and Amazon Aurora users. To access the review's full transcripts, download our report.
"The solution’s scalability is good since we don’t need to take a maintenance window during unpredictable workloads. I like the solution’s behind-the-scenes happenings. It is a great feature."
"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."
"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."
"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."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"The most valuable feature of Amazon Aurora is SQL standardization, it doesn't have its own syntax which is good. It has a lot of hands-off self-management type of activities, such as log rolling and auto-scaling."
"Many developers like SQL Server."
"SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
"The product's initial setup phase was simple."
"The solution is very intuitive and easy to use."
"It's great that the nodes are synchronized so if you lose one it automatically moves to another."
"As a data warehouse and storage solution, it's quite good."
"The features that we have found the most valuable are reliability, availability perspective, and current scalability."
"SQL Server is a stable product."
"It would have been helpful if they had provided some benchmarking numbers."
"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."
"The product's distributed query process for MySQL needs improvement."
"The pricing could improve. It should be reduced."
"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."
"I would like to see more AI-related features in future releases."
"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."
"From a development perspective, the solution needs to be a lot easier to understand or it needs to be easier to implement API packages for connection pooling so we don't have connection interruptions when, let's say, a hundred people simultaneously access the network on a given system, utilizing a specific or single database."
"The solution is rather expensive."
"SQL Server could integrate better with other platforms."
"I have experience working with SQL Server 2016 and older versions, including handling JSON data. Initially, I found the JSON capabilities to be less helpful, but over time, they have greatly improved. SQL Server now offers extensive capabilities for working with various forms of data, particularly when communicating with text, such as in JSON format. I particularly prefer working with these features on Azure, as it provides numerous possibilities, especially in the field of business intelligence (BI). Additionally, the serverless platform offered by Azure is highly beneficial and makes tasks easier to manage."
"Performance could be improved."
"The pricing and quality of the product could be improved."
"The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience."
"CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server."
Amazon Aurora is ranked 11th in Relational Databases Tools with 7 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Amazon Aurora is rated 7.8, while SQL Server is rated 8.4. The top reviewer of Amazon Aurora writes "Easy-to-manage platform with a valuable auto-scaling feature ". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Amazon Aurora is most compared with Oracle Database, MariaDB, CockroachDB, MySQL and SAP HANA, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and MySQL. See our Amazon Aurora vs. SQL Server report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.