Database migration in the openIMIS open source health insurance management system (Bachelor Thesis, Finished)


Michel Borer


The Swiss Tropical and Public Health Institute has, together with their partners, created the openIMIS initiative, a health financing software project for developing countries that started out as proprietary software but is now moving to become open source. This move requires a migration from the proprietary SQL Server database system to the open source PostgreSQL system. In this thesis, tables and views have been created in the new database system with the help of an ORM tool, all functions and some of the stored procedures have been migrated, and optimisations to the current implementation of the software have been proposed. Additionally, a migration tool that can pull data from the SQL Server database and store it in the PostgreSQL database has been created.

Start / End Dates

2020/04/06 - 2020/07/05


Research Topics