Transcat

Flexible & Secure Windows Database Migration

Simplified Database Migration

Transcat partnered with EagleDream to successfully migrate their on-premise systems to a single SQL server database in Amazon Web Services cloud.

Trust in Every Measure

Transcat partnered with EagleDream to successfully migrate their on-premise systems to a single SQL server database in Amazon Web Services cloud.

Challenge

When Transcat partnered with EagleDream, they were running twenty regional office servers on-premise and were experiencing a myriad of challenges. Not only were their hardware and software outdated, but their team experienced capacity planning issues and high local network latencies. Operating multiple on-premise servers were costing Transcat both time and money.

Solution

EagleDream proposed to migrate Transcat’s on-premise systems to a single SQL server database in Amazon Web Services cloud. This would eliminate Transcat’s need for regional replicas of their servers. EagleDream began the migration by setting up a master SQL Server database on Amazon EC2 and a replica that was restored on a sufficiently larger Amazon EC2 instance in Transcat’s virtual private cloud.

 

Transcat performed testing to evaluate overall response time and data integrity. Once it was established that the master server and replica were a success, EagleDream began migrating each of the regional offices to a replica of the new AWS SQL server. The regional office servers were migrated one at a time, and as a result, all of the regional offices were successfully operating on the new AWS SQL server.

 

EagleDream is helping Transcat to build out a Data Lake with over 80 KPIs needed by Senior Management to help them monitor the business. EagleDream is leading the effort to transfer data out of Transcat’s on-premise Microsoft SQL Server databases and AS4-00 systems into an AWS native Data Lake. A Visualization environment will be built with Amazon Quicksight.

Results

EagleDream lifted various obstacles faced by the Transcat team by successfully migrating their databases to the AWS cloud.

AWS Services Used

  • Amazon EC2
  • Amazon RDS

Original Infrastructure

  • Microsoft SQL Server 2008

OS Platforms

  • Microsoft Windows 2008
All the good stuff that made it successful

Key Benefits & Successes

Like what you see?

View Our Other Work

Let’s Start Building

Have an idea that you would like to share? We want to help bring your ideas from concept to reality.