Migrating AdventureWorks to Postgres

Aaron Cutshall

One of the advantages that SQL Server developers have enjoyed is a comprehensive sample database that touches on all aspects and operations of a database. That same sample database, AdventureWorks, is now available for Postgres!

However, it is not just the data in tables but all views, triggers, procedures, functions, and other database objects. Data type differences, procedural differences, and others are highlighted and discussed. This session highlights several differences between SQL Server and Postgres using AdventureWorks as an example.