.png)
.png)
IDT Solution
IDT designed and executed a secure, managed migration from on-premises Microsoft SQL Server to Amazon Aurora PostgreSQL on AWS. Amazon DMS was used to replicate data with minimal downtime, enabling a smooth transition while keeping the reporting service available throughout the migration process.
The target architecture leverages Amazon RDS Aurora to deliver improved scalability, resilience, and operational simplicity. IDT also established repeatable migration runbooks and CI/CD patterns to support future database migrations as part of CNP Operating Corporation’s broader cloud modernization program. The resulting platform decouples the reporting workload from data-center constraints and aligns it with AWS cloud-native best practices.
DATABASE MIGRATION FOR AN ONLINE PAYMENTS PROVIDER
Executive Summary
CNP Operating Corporation is a digital payments provider in the midst of a broader cloud migration to AWS. As part of this initiative, the company needed to modernize a critical reporting database that supports merchant-facing analytics and operational reporting. The existing on-premises Microsoft SQL Server environment was costly to operate, difficult to scale during peak periods, and tightly coupled to data-center processes.
To address these challenges, CNP Operating Corporation partnered with Innovative Digital Transformation LLC (IDT) to deliver a secure, managed database migration to AWS. The project re-platformed the reporting workload from Microsoft SQL Server to Amazon Aurora PostgreSQL using Amazon RDS Aurora and Amazon DMS. The result is a cloud-native, scalable platform that improves performance, resilience, and operational efficiency while reducing licensing and infrastructure overhead.
DATABASE MIGRATION FOR AN ONLINE PAYMENTS PROVIDER
Executive Summary
CNP Operating Corporation is a digital payments provider in the midst of a broader cloud migration to AWS. As part of this initiative, the company needed to modernize a critical reporting database that supports merchant-facing analytics and operational reporting. The existing on-premises Microsoft SQL Server environment was costly to operate, difficult to scale during peak periods, and tightly coupled to data-center processes.
To address these challenges, CNP Operating Corporation partnered with Innovative Digital Transformation LLC (IDT) to deliver a secure, managed database migration to AWS. The project re-platformed the reporting workload from Microsoft SQL Server to Amazon Aurora PostgreSQL using Amazon RDS Aurora and Amazon DMS. The result is a cloud-native, scalable platform that improves performance, resilience, and operational efficiency while reducing licensing and infrastructure overhead.
CNP Operating Corporation
Case Study
The Challenge
The reporting database powers a microservice responsible for generating periodic and ad-hoc reports for merchants, including settlements, fees, chargebacks, and key performance indicators. Running on an on-premises Microsoft SQL Server stack, the system was expensive to maintain, slow to scale, and strained during month-end reporting peaks.
As part of its AWS adoption strategy, CNP Operating Corporation needed to migrate this workload to the cloud with minimal downtime and without disrupting merchant reporting. In addition, the database engine needed to be re-platformed to PostgreSQL to reduce licensing costs and align with the target AWS architecture. The migration also had to preserve—and ideally improve—reporting accuracy, performance, and availability, while establishing repeatable patterns for future database migrations.
The Challenge
The reporting database powers a microservice responsible for generating periodic and ad-hoc reports for merchants, including settlements, fees, chargebacks, and key performance indicators. Running on an on-premises Microsoft SQL Server stack, the system was expensive to maintain, slow to scale, and strained during month-end reporting peaks.
As part of its AWS adoption strategy, CNP Operating Corporation needed to migrate this workload to the cloud with minimal downtime and without disrupting merchant reporting. In addition, the database engine needed to be re-platformed to PostgreSQL to reduce licensing costs and align with the target AWS architecture. The migration also had to preserve—and ideally improve—reporting accuracy, performance, and availability, while establishing repeatable patterns for future database migrations.
The Challenge
The reporting database powers a microservice responsible for generating periodic and ad-hoc reports for merchants, including settlements, fees, chargebacks, and key performance indicators. Running on an on-premises Microsoft SQL Server stack, the system was expensive to maintain, slow to scale, and strained during month-end reporting peaks.
As part of its AWS adoption strategy, CNP Operating Corporation needed to migrate this workload to the cloud with minimal downtime and without disrupting merchant reporting. In addition, the database engine needed to be re-platformed to PostgreSQL to reduce licensing costs and align with the target AWS architecture. The migration also had to preserve—and ideally improve—reporting accuracy, performance, and availability, while establishing repeatable patterns for future database migrations.
The Benefits
CNP Operating Corporation now operates a high-performance, cloud-native reporting database that scales seamlessly during peak reporting periods. Merchant reports are generated faster and more reliably, with improved availability during month-end and high-demand scenarios.
By re-platforming to Amazon Aurora PostgreSQL, the organization reduced licensing and operational costs while improving overall system resilience. The migration also established a proven, repeatable approach for moving additional workloads to AWS, accelerating the company’s broader cloud transformation.
We’re very pleased with our migration from on-prem Microsoft SQL Server to Amazon Aurora PostgreSQL on AWS. IDT executed the transition smoothly with minimal downtime, and we felt confident at every step. Our reporting microservice is now faster and more resilient - especially during month-end peaks - and the platform scales effortlessly as demand grows. We’ve also reduced licensing and operational overhead while improving the accuracy and availability of merchant reports. The cloud-native setup gives us peace of mind and a repeatable pattern for future workloads. We appreciate IDT’s professional approach and successful delivery.
Konstantin Degtyaryov, CTO CNP Processing GmbH
