Choosing the Best Path When Migrating Unsupported Microsoft SQL 2008 To AWS

Written by

Jeremy Schiefer

2/1/2019

Choosing the Best Path When Migrating Unsupported Microsoft SQL 2008 To AWS

On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. After this date, Microsoft will no longer support these products via product enhancements (service packs/CUs) and security updates.

There are two main ways to run SQL on AWS:

Amazon RDS for SQL Server

Amazon RDS for SQL Server
A fully managed service that offers several versions of SQL while offloading the database administration tasks like managing backups, detecting failures and recovering and much more.

Amazon EC2 running Windows Server and SQL Server

Amazon EC2 running Windows Server and SQL Server
The EC2 option offers you flexibility to run a database and control the underlying operating system. You can run for as much, or as little time as you need with complete control over the Windows settings.

SQL Server Versions

SQL Server comes in a variety of different versions, so it is important to compare the features to make sure you are running the right one. Picking too large of a feature set could end up costing your business unnecessary licensing costs. View a high-level comparison of the different versions

 

Instance Types

AWS offers a variety of different instance types for both EC2 and RDS. Picking the right instance type can also save you money. More importantly, matching the instance type and size with the workload will better improve performance. Learn more about: EC2 instance types and RDS instance types

Innovative Solutions is an Advanced AWS Consulting Partner and Solution Provider helping SMBs migrate to AWS. Our team of certified cloud architects have the expertise in both Microsoft and AWS to build scalable, reliable, and cost-effective services designed specifically for each business’ need.

Have a question or want to learn more?

Learn more about the end-of-life for SQL 2008 + Microsoft Server 2008 - Click Here

Learn more about our AWS services - Click Here

Contact us today to get the conversation started - Click Here