SQL Server to PostgreSQL: Migration Challenges & Solutions

on YouTube ↗45m

" summary

Migrating from SQL Server to PostgreSQL hits specific pain points: schema and T‑SQL incompatibilities, backups, collation and case sensitivity, and MVCC maintenance. Practical answers: use pg_dump for logical exports and pg_basebackup (Postgres 17 adds incremental) plus WAL archiving for PITR; use Babelfish to reduce T‑SQL rewrite; use CI text/ICU collations or lowercase identifiers for case handling; use pgloader or COPY for bulk loads, foreign data wrapper and logical decoding for CDC, and tune autovacuum, temp buffers and tablespaces. Teams report talking to ~100 DBAs and find these tools largely effective.

AI-written summary · about

" chapters (13)

1. 0:00Introduction and motivation
2. 3:25Architectural comparisons
3. 7:24Read and write operations
4. 10:01Recovery and log models
5. 11:44Memory architecture
6. 14:16Temporary object management
7. 16:42Concurrency and isolation
8. 19:47Developer and data features
9. 28:18Collation and case sensitivity
10. 31:50Authentication and federation
11. 34:40Access methods and syntax
12. 36:24Administrative tasks
13. 38:58Migration and tooling

" related talks

• 27mMigrating from MSSQL to PostgreSQLRobert Bernier · Percona Tech Days 2020
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025
• 46mPostgres for the SQL Server DBAPat Wright · PGConf NYC 2022
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 38mSwitching Teams: Moving an Application from MySQL to PostgreSQLJulie Baumler · Open Source Bridge 2013
• 36mTales from the Postgres Front, and What We Can LearnMarc Linster · PostgresOpen 2014