Select Page

Comparing DBaaS Options from Amazon and Microsoft

JP Chen | | December 3, 2015

Comparing DBaaS Options from Amazon and MicrosoftCloud-based computing holds promise for businesses that no longer need to own and maintain costly fixed-hardware assets. Seeing the benefits of lower costs and scale-as-needed capability, businesses are pursuing the cloud in ever increasing numbers. Database-as-a-Service (DBaaS) offerings are increasingly attractive to IT professionals.

Microsoft Azure SQL Databases is part of the larger Azure universe of cloud-based services. As the name implies, it is a SQL-based system that offers hybrid database and storage solutions for IT professionals who want some assets to remain fixed in their datacenters.

Amazon Relational Database Service (RDS) “makes it easy to set up, operation, and scale a relational database in the cloud,” according to Amazon. The company now offers six different database engines.

Datavail has released a white paper exploring two DBaaS offerings, “Microsoft Azure SQL Databases vs. Amazon RDS: Apples and Oranges or Two Peas in a Pod?” In it, we look at these similar services and parse out the differences in features, including system architecture, backup capability, scaling, and database size. We also discuss pricing, although both services are new enough that details on pricing are still in flux.

Microsoft Azure SQL Databases is part of the larger Azure universe of cloud-based services. As the name implies, it is a SQL-based system that offers hybrid database and storage solutions for IT professionals who want some assets to remain fixed in their datacenters.

Amazon Relational Database Service (RDS) “makes it easy to set up, operation, and scale a relational database in the cloud,” according to Amazon. The company now offers six different database engines.

Below is a brief summary of the features of each service. For more details, please download our white paper. (URL)

Below is a brief summary of the features for each service. For more details, please contact Datavail.

  • Architecture: Amazon dedicates hardware resources to the user, while Microsoft shares resources among users.
  • Backup and Restore: Amazon offers eight days of backups plus log backup and restoration, while Microsoft requires users to configure backups manually.
  • Scaling Up and/or Scaling Out: Both services allow users to scale both up (adding more CPUs) or out (increasing the I/O in the environment).
  • Database Size: The maximum size for a database in Amazon RDS varies based on the database engine chosen (you can use any one of six options). Microsoft Azure SQL Databases limits database size and number based on the type of account purchased.
  • Tools: Amazon RDS is an instance of MySQL and offers MySQL features and tools, along with a few added tools for production database migration. Microsoft uses features from SQL Server 2008 and tools in SQL Server Management Studio 2008 R2.
  • Container Support: Both services offer container support with Docker integration for the use of containers.
  • Database Offerings: Amazon RDS offers a choice of database engines, including MySQL, Aurora, PostgreSQL, Oracle, DynamoDB, and Maria DB. Azure allows users to create a MySQL database using ClearDB.

So how do you think the two compare? Let us know, we’d love to hear your thoughts.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018
oracle , aws

Oracle Cloud vs Amazon Cloud – Which is right for you?

Choosing the right cloud computing vendor for your database needs is difficult. This blog post takes you through the pros and cons of Oracle vs Amazon Cloud.

Megan Elphingstone | July 20, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS