Demystify Migrating SQL Server to Aurora PostgreSQL

Dustin Brown, Chandra Pathivada

We will discuss the migration process from start to finish when re-architecting to Aurora Postgres from SQL Server. You will learn how to easily convert database Schema objects like tables, views, and stored procedures to a PostgreSQL compatible schema. This will include common schema conversion challenges and estimating level of conversion difficulty during the planning phase. We will also discuss migration mechanisms, migration purpose-built-tools, and migrating with minimal downtime. Lastly, we will discuss lessons learned and best practices captured directly from real migration scenarios in the field.