My Hands-On Migration of a Node.js App and PostgreSQL Database from Azure to AWS

My migration lab, from a blocked local network to PostgreSQL on RDS and a private application on EC2.

Full load: 100%. Three tables validated. Zero mismatched records.

Those were the results on my AWS DMS dashboard. The data had made it from Azure to Amazon RDS, and the row counts agreed.

There was still work hiding behind that success: sequence-backed IDs, defaults, constraints, and permissions needed attention before the target database was ready for the application.

I built this lab to practice moving a Node.js order-management app and its PostgreSQL database to AWS. I used an Azure VM as the simulated on-premises source. There were only three tables, which made it easy to compare the data while I worked through the networking, database cutover, and application move.

The database copy was one step.…