Select Page

Comparing DBaaS Options from Amazon and Microsoft

Author: JP Chen | | December 3, 2015

Cloud-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.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.

Vijay Muthu | February 4, 2021
sharepoint ideas

Using SharePoint: 9 Awesome Things You Can Do With SharePoint

Become familiar with these 9 uses for SharePoint that you can execute in just a few clicks without using any code. Learn more about using SharePoint here!

Amol Gharat | May 23, 2017

Scripting Out SQL Server Logins, Server Role Assignments, and Server Permissions

This blog reviews how you can generate scripts for SQL server logins, role assignments, and server permissions for a smooth migration.

JP Chen | October 1, 2015

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

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