SQL Server migration & modernization powered by generative AI
Proposed session for SQLBits 2026TL; DR
Experience how generative AI transforms SQL Server migrations to PostgreSQL. This hands-on workshop demonstrates using Amazon Q Developer to automate code conversion, accelerate database schema migration, and modernize applications for Aurora PostgreSQL Serverless v2.
Session Details
In this workshop, discover a comprehensive migration and modernization experience that guides you through the process of migrating your SQL Server database and application-associated embedded SQL code to PostgreSQL. The workshop uniquely incorporates Amazon Q Developer, an AWS generative AI augmented solution, to help alleviate labor-intensive tasks and accelerate the database migration process. You will gain practical migration and modernization experience with live applications while learning how to transform their database systems to Aurora PostgreSQL Serverless v2. While the workshop targets Aurora PostgreSQL, the mechanisms also broadly apply to migrating other commercial relational databases to open source relational databases.
3 things you'll get out of this session
1- Master practical techniques for migrating SQL Server databases and embedded application code to PostgreSQL using Amazon Q Developer's generative AI capabilities to reduce manual effort and accelerate delivery
2- Gain hands-on experience modernizing live applications while transforming database systems to Aurora PostgreSQL Serverless v2 with optimized performance and cost efficiency
3- Learn migration patterns and best practices applicable across various commercial-to-open-source database transitions, enabling you to apply these skills beyond SQL Server to PostgreSQL scenarios