Level: Intermediate
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:
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.