The largest chain of hospitals in Maharashtra – Sahyadri Hospitals was looking for a server refresh for their applications. They chose to migrate data center servers running MSSQL databases to Amazon Web Services’ more dynamic and flexible Relational Database Service (RDS) for PostgreSQL on the Cloud. Migrating from legacy MSSQL Server databases can be time-consuming and resource-intensive.

When transferring existing databases, we can use the AWS Database Migration Service (DMS) to automate the migration of database schema and data, but the application itself frequently requires extra work, such as rewriting application code that interacts with the database. Because of Babelfish, Aurora PostgreSQL now understands and supports Microsoft SQL Server’s communication protocol, allowing SQL Server-based projects to run with Aurora with fewer code modifications.

As a result, the time and effort necessary to alter and migrate MS SQL Server or newer applications to Aurora are minimized, resulting in faster, safer, and more cost-effective migrations.

The customer was already utilizing Amazon RDS for SQL, however, it has lower performance and availability when compared to Aurora PostgreSQL

The Customer had an existing data size of 300 GB and needed to migrate to the Aurora PostgreSQL database

It has been expected to grow Yearly by 600 GB in size and it has a total of 298 tables in the database in total

Planned to migrate the entire database to Aurora PostgreSQL for faster performance and availability

Provision the AWS Database Migration Service instance

Creating source database and target database endpoints.

Creating the list of tasks that specifies the data migration plans discussed with the internal team

Migrate the Database using Database Migration Service.

Data validation after the post-migration with stakeholders.

Please write to us at contactus@1cloudhub.com, if you wish to explore further on this deployment.