PgConf.Russia 2017 talks

Migrating DocsVision EDMS from MS SQL to Postgres

Yury Zhukovets
Digital Design / Docsvision, Expert group leader

Yury Zhukovets is a leading specialist of Digital Design company on databases and BI, as well as on high-load systems with large volumes of data processing. For the last 7 years he works mainly on document management systens for government structures and major commercial companies.

This talk is about migrating an electronic document management system from MS SQL to PostgreSQL 9.5 or higher as part of the import phaseout initiative. We will touch upon architecture specifics, as well as describe the problems we encountered when migrating T-SQL code to pgsql, and how we resolved them.

Learn more at