Migrate and Modernize the MSSQL on RDS to PostgreSQL on Aurora (Babelfish) Using DMS
We helped to Migrate and Modernize the MSSQL on RDS to PostgreSQL on Aurora (Babelfish) Using DMS
About the client
The largest chain of hospitals in Maharashtra 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.
Database storage items and database code objects from MSSQL to PostgreSQL on Aurora successfully
Utilizing the TDS and PostgreSQL endpoints, verify the moved data and test the functionality
Performance should be similar to MSSQL on RDS (confirmed through performance benchmarking)
CDN delivers the e-commerce website with low latency and high transfer speeds. WAF has been implemented on CDN to protect the web application against threats.
Please write to us at firstname.lastname@example.org, if you wish to explore further on this deployment.