Our blog is an authoritative resource offering expert insights, practical guidance, and in-depth analyses on secure cloud architecture, scalable systems design, advanced data engineering, and innovative programming practices. Tailored for enterprise and government decision-makers, our articles provide thought leadership, real-world case studies, and best practices designed to help organizations navigate complex technical challenges and achieve mission-critical success.
Jim Collins’ Built to Last shows that embedding expertise into processes helps companies scale and innovate—a practice now applied by software teams through CI/CD pipelines. With more development aspects moving “as code,” teams can focus on core tasks like bug fixes and feature releases, marking a transformative trend.
AWS provides tools for migrating data between systems, including the Schema Conversion Tool and the Database Migration Service. This article presents a solution for migrating the HierarchyID datatype from Microsoft SQL Server to the LTREE datatype in AWS Aurora PostgreSQL.
This is an extension of the previous article for migration of the HierarchyID data type to LTREE. This blog focuses on a continuous (CDC) migration with DMS.