Let’s Start Building

Dream Build Soar

Cloud

Development

Web Design

Security

Compliance

Communication

Call us anytime

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

IMPROVED PERFORMANCE AND RELIABILITY

Using Amazon RDS, Transcat is able to instantly launch and configure a database server for immediate use. Their databases are also highly available and their teams can rest confidently knowing that a recovery plan is in place in event of failure.

SIMPLIFIED MANAGEMENT AND MONITORING

Transcat efficiently consolidated their servers from twenty to one which has made management and monitoring significantly easier in addition to reducing operational costs.

MORE OPPORTUNITY TO SCALE

This database migration effort has given Transcat the flexibility to build and scale their environment quickly. Other applications will be able to be migrated to AWS seamlessly as a result.

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.
READY TO START BUILDING?

Let us help you bring your idea from concept to reality. Complete the following form and a member of our team will be in touch.

Phone: 1.844.4EAGLEDREAM | Email: info@eagledream.com