You will need to make a couple of significant decisions right off the bat if you want to move your SQL Server database to the cloud. First of all, you will need to select a cloud platform, with Microsoft Azure and Amazon Web Services (AWS) being the two leading choices at this time. Next, you will need to decide if you want to run your SQL Server database on the platform’s cloud-based virtual machines (VMs) or use the platform’s managed SQL Server database.
These two choices result in the four options Azure VM, Azure SQL Database, Amazon EC2, and Amazon RDS for SQL Server.
Running your database on cloud VMs has greater flexibility on configuration, but it also requires more expertise to administer. On the other hand, a managed cloud database may be a better choice if you do not have the resources for a dedicated database administrator. That may be especially relevant if you are developing a new database rather than migrating an existing one.
Read the 5-page whitepaper “Databases on Cloud Virtual Machines versus Managed Cloud Databases” to learn about the differences between the different options.
To learn more about IDERA’s solution for managing databases in the hybrid cloud, view the cloud solutions webpage.