Migrating from MSSQL to PostgreSQL

on YouTube ↗27m

" summary

Real migration steps: compile and install the tds_fdw foreign data wrapper on a Linux/Postgres 9.6+ build, create foreign tables for the SQL Server information_schema and data, then copy ~several hundred GB into PostgreSQL (short of 100 tables and several hundred views). Apply primary keys then foreign keys to catch data/encoding corruption, create trigger shells and skeleton functions to compile then refactor, and iteratively rebuild views until only problematic definitions remain. Command‑line SQL Server clients on Linux validate ports, users and truncated catalog issues (2KB view storage).

AI-written summary · about

" chapters (17)

1. 0:00Intro
2. 1:46SUMMARY STEPS
3. 2:42SUMMARY DETAILS
4. 7:48The SECRET SAUCE
5. 10:58System Catalog Vs Information Schema
6. 12:07PREPARING THE TARGET DATABASE
7. 14:21INSTALLING POSTGRES
8. 15:19THE tds faw FOREIGN DATA WRAPPER
9. 16:14CONNECTING PG AND MSSOLE
10. 16:38IMPORTING TABLES
11. 17:06PROCESSING FUNCTIONSISPRO
12. 18:27MASSAGING POSTGRES
13. 22:53POPULATE TABLES
14. 23:25IMPORT SYSTEM CATALOGS
15. 25:08POPULATE SYS CATALOGS
16. 25:42PROCESS THE TRIGGERS
17. 26:12PROCESS THE VIEWS

" related talks

• 45mSQL Server to PostgreSQL: Migration Challenges & SolutionsSameer Kumar, Roneel Rohitesh Kumar · FOSSASIA PGDay 2025
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025
• 46mPostgres for the SQL Server DBAPat Wright · PGConf NYC 2022
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 38mSwitching Teams: Moving an Application from MySQL to PostgreSQLJulie Baumler · Open Source Bridge 2013
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 34mPartitioning and Data Migrations Using PostgreSQL as an ExampleDenis Ivanov · HighLoad++ 2014
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025