Overcoming Challenges in SQL Server to PostgreSQL Migrations: Mapping Backups, Collations, and Case Sensitivity
Presented by:
Sameer Kumar
Sameer Kumar is a Principal Database Specialist TAM at AWS, helping enterprise customers optimize database operations across RDS, Aurora, and DocumentDB. With 15+ years of experience, he specializes in scaling database infrastructure and achieving high availability up to five 9s. Throughout his career, Sameer has guided enterprises managing database fleets ranging from hundreds to tens of thousands of instances. Previously as a Database Solution Architect, he has architected solutions for Retail, BFSI, and Telecom sectors, working with both relational and noSQL databases.
Roneel Kumar
Roneel Kumar is a Senior Relational Databases Specialist Solutions Architect in the AWS Worldwide Database Services Organization (DBSO). His Core area of expertise is in designing, building, and implementing Database Modernization Platform for customers with PostgreSQL Databases.
No video of the event yet, sorry!
SQL Server to PostgreSQL migrations present a complex array of technical differences that can challenge even experienced DBAs - we've seen this firsthand across hundreds of hours spent with customers managing databases from tens of GiBs to several terabytes. Successfully navigating these migrations requires deep understanding of how critical components like backups, collations, and case sensitivity differ between platforms. In this talk, we'll compress our experience from 500+ hours of migration consulting into a practical guide that helps database administrators (DBAs), developers, and IT professionals understand and overcome these core challenges.
We'll focus on four critical areas that consistently emerge as migration roadblocks:
- Architectural Differences
- Data Storage and Access
- Backup Strategy Differences
- Collation and Character Set Challenges
Target Audience: DBAs and developers planning PostgreSQL migrations. Basic knowledge of both databases helpful but not required.
This talk distills our extensive experience into practical, actionable guidance, focusing exclusively on open-source solutions that attendees can implement immediately.
- Date:
- 2025 October 17 15:10 +11
- Duration:
- 40 min
- Room:
- Oxford I + II
- Conference:
- PG Down Under 2025
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Medium