Migrating to PostgreSQL
![](https://www.socallinuxexpo.org/sites/default/files/styles/square_thumbnail/public/speakers/Screen%20Shot%202018-10-31%20at%202.23.56%20PM.png?itok=WX0A8y6M)
Convincing decision makers to migrate databases to an open source platform when they are already running proprietary software can be challenging. I will walk through a case study of a successful Microsoft (MS) Windows / SQL Server to Ubuntu / PostgreSQL migration that I have been part of as a consultant to the Energy Division (ED) at the California Public Utility Commission (CPUC). The CPUC ED is responsible to securely manage the data produced by their $1B per year investment in energy efficiency and demand side management, and to make those data available to their independent evaluators to the public. ED began running their MS Windows / SQL Server database server in 2009. Today they run a cluster of open source servers running PosgreSQL. I’ll cover the key barriers we faced in migrating from MS SQL Server to PosgreSQL, and how we overcame them.