Want to create an interactive transcript for this episode?
Podcast: Chaos Computer Club - recent audio-only feed
Episode: Migrating Legacy and Proprietary Databases to PostgreSQL (clt26)
Description: European organisations and companies are increasingly re-evaluating proprietary database dependencies as digital sovereignty becomes more critical than ever. This talk serves as a pragmatic field guide for migrating from legacy or vendor-locked databases (Oracle, SQL Server, Sybase ASE, Db2) to PostgreSQL.
Drawing from years of hands-on experience in heterogeneous migrations and tool development, we will explore a comprehensive decision framework for successful transitions. The session compares offline strategies (dump/restore, ETL, bulk COPY) against online, near-zero-downtime approaches (CDC, logical replication, dual-write), with a special focus on designing reversible cutovers to minimize operational risk.
We will discuss a toolbox for schema...