DB Modernization MS SQL on RDS > PostgreSQL on Aurora

A French container transportation and shipping company with 30K Million USD Revenue.

Their agency application is being moved from on-premises to the AWS cloud. Around 21 MSSQL database servers are used by the agency’s applications. They were looking into open-source options like PostgreSQL and MYSQL to avoid paying Microsoft for software assurance.

Migrating from legacy SQL Server databases can be time-consuming and resource-intensive. When transferring existing databases,  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. Aurora PostgreSQL now understands Microsoft SQL Server’s, supports the same communication protocol due to Babelfish, so the SQL Server-based projects may now run with Aurora with less code modifications.

As a result, the time and effort necessary to alter and migrate SQL Server or newer applications to Aurora is minimised, 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 250 GB and needed to migrate to the Aurora PostgreSQL database.

It has been expected to grow Yearly by 400 GB in size and it has a total of 89 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.