← All presentations

How to Migrate from SQL Server to Postgres

Download

Abstract

Many who think of the database as merely a data container assume that moving from one to another is trivial. Although data lives in tables, it is visible through views, processed by procedures, transformed in triggers, and featured in functions. The logic in all these must also be translated to the new platform including:

  • Data Types & Extensions
  • Tables, Primary/Foreign Keys & Indexes
  • SQL queries & Views
  • PL/pgSQL in Stored Procedures & Functions
  • Triggers & other Miscellaneous Items

Presented at:

  • Day of Data Seattle, Seattle, WA on November 13, 2026