by  Sergii Porokh

8 Issues Moving MS SQL Cluster from BareMetal to AWS

clock-icon-white  2 min read

Here are the eight most common challenges that can crop up during an MS SQL migration from BareMetal to AWS – one problem at a time.

Over the last few months, several clients have told us that they are unhappy with their production environments. Most are interested in decreasing operational costs and moving to cloud platforms in place of BareMetal; some weren’t satisfied with the support and services offered by their current provider and wanted to migrate to a bigger one.

In either case, most of these issues required us to move an MS SQL database (since most enterprise-level companies use Windows and MS SQL/Oracle to manage operations) to a new platform. Here are the eight most common challenges that can crop up during an MS SQL migration from BareMetal to AWS – one problem at a time.

1. Compliance

When working with innovative, cutting-edge IT technologies, it is easy to forget about security compliance. But its absence could destroy your seemingly perfect deployment plan. Many DevOps engineers skip this critical step. For example, RDS is not HIPPA compliant with MS SQL (only with Oracle and MySQL engines).

ms-sql-1

Hopefully these tips will help you sidestep some of the hurdles we’ve already jumped ourselves. If you’re curious to see how changes like these create lasting impact, check out our case study on tool migration to the AWS Cloud Computing Platform.