DB Modernization MS SQL on RDS > PostgreSQL on Aurora
We helped our top customer in DB Modernization MS SQL on RDS > PostgreSQL on Aurora
About the client
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
Successfully migrate database-storage objects & database - code objects from MSSQL to PostgreSQL on Aurora
Application functionality will not be affected by database migration (100% unit & integration test success)
Performance should be like MSSQL on RDS (confirmed through performance benchmarking)
Please write to us at email@example.com, if you wish to explore further on this deployment.