IT Central Station is now PeerSpot: Here's why

Amazon Aurora vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
Amazon Logo
1,684 views|1,563 comparisons
Microsoft Logo
21,417 views|16,448 comparisons
Featured Review
Buyer's Guide
Relational Databases Tools
July 2022
Find out what your peers are saying about Microsoft, Oracle, Teradata and others in Relational Databases Tools. Updated: July 2022.
622,949 professionals have used our research since 2012.
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."

More Amazon Aurora Pros →

"It is a typical database solution, and it is working well so far. It is easy to use, and it is also very common and popular, which makes it easy to find a support partner.""I've been using SQL Server for 20 years, and there is nothing that it can't do. It is awesome.""The most valuable feature of SQL Server is the performance.""It is easy to use and very stable.""It's great that the database engine is always on.""Stability and usability, which is quite simple, are two of the solution's most valuable features.""The security and vulnerability management are well-managed through the vendor.""It is easy to deploy and easy to maintain."

More SQL Server Pros →

Cons
"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."

More Amazon Aurora Cons →

"The backup capacity needs to be bigger.""Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved.""You do need to have technical knowledge in order to install the solution. It's not something a layperson can do.""There should be more security updates for the product.""I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee.""It would be nice if they can reduce its price.""The configuration process can be a little complex.""I would like to see better integration between their link server and other platforms, such as IBM."

More SQL Server Cons →

Pricing and Cost Advice
  • "The price could be lower compared to its competitors."
  • More Amazon Aurora Pricing and Cost Advice →

  • "Pricing is reasonable for small organizations, but the scaling increases the price."
  • "We didn't have any licensing costs for SQL Server."
  • "We pay approximately $12,000 USD per month for both the server and the license."
  • "The price could be cheaper."
  • "Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • "The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    622,949 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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.
    Top Answer:The price could be lower compared to its competitors.
    Top Answer: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. Right now… more »
    Top Answer:We're satisfied with the stability.
    Top Answer:Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.
    Ranking
    Views
    1,684
    Comparisons
    1,563
    Reviews
    1
    Average Words per Review
    679
    Rating
    9.0
    Views
    21,417
    Comparisons
    16,448
    Reviews
    168
    Average Words per Review
    444
    Rating
    8.2
    Comparisons
    Also Known As
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

    Amazon Aurora is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. It provides the security, availability, and reliability of commercial databases at 1/10th the cost. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups.

    Amazon Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance. It delivers high performance and availability with up to 15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs).

    Visit the Amazon RDS Management Console to create your first Aurora database instance and start migrating your MySQL and PostgreSQL databases.

    SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

    Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

    Offer
    Learn more about Amazon Aurora
    Learn more about SQL Server
    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.
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company25%
    Comms Service Provider19%
    Media Company10%
    Financial Services Firm8%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Comms Service Provider23%
    Computer Software Company21%
    Financial Services Firm8%
    Government5%
    Company Size
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise14%
    Large Enterprise71%
    REVIEWERS
    Small Business43%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise16%
    Large Enterprise64%
    Buyer's Guide
    Relational Databases Tools
    July 2022
    Find out what your peers are saying about Microsoft, Oracle, Teradata and others in Relational Databases Tools. Updated: July 2022.
    622,949 professionals have used our research since 2012.

    Amazon Aurora is ranked 10th in Relational Databases Tools with 1 review while SQL Server is ranked 1st in Relational Databases Tools with 167 reviews. Amazon Aurora is rated 9.0, while SQL Server is rated 8.2. The top reviewer of Amazon Aurora writes "Provides maintainability that is offloaded to the service provider and comes with disaster recovery feasibility". On the other hand, the top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". Amazon Aurora is most compared with MariaDB, Oracle Database, Citus Data, IBM Db2 Database and Oracle Database Cloud Service, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, MariaDB and SAP Adaptive Server Enterprise.

    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.