Introducing DarcyIQ — our AI platform built to help teams move faster without sacrificing quality Explore DarcyIQ →

Categories

SQL 2008 End of life

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

Related Case Studies

Innovative Solutions Launches Forward Deployed Services

Innovative Solutions Launches Forward Deployed Services, Bringing Embedded Engineering to Growing Businesses

Innovative Solutions, an Amazon Web Services (AWS) Premier Tier Services Partner that delivers AI and data services to growing businesses, today announced the launch of Forward Deployed Services, a new service line that embeds Forward Deployed Engineers (FDE) and architects directly into customer environments to build, manage, and continuously optimize AI and cloud solutions. The offering brings FDE delivery to the growing businesses that need it most.

Read More
I Trust, Global Politics & Agentic Delivery - AI Unplugged Episode 14

AI Trust, Global Politics & Agentic Delivery

AI is speeding up work. But speed is starting to expose a new problem: trust. In Episode 14 of AI Unplugged: AI Trust, Global Politics & Agentic Delivery, we unpack why AI favorability can fall as usage rises, especially when outputs feel influenced, accuracy feels inconsistent, and people start questioning what’s behind the answer.

AI Unplugged is available on YouTube and where ever you listen to podcasts.

Read More