Explore the migration of openIMIS database from Microsoft SQL Server to PostgreSQL
Become familiar with the existing openIMIS implementation in general and the openIMIS database in particular.
Create the openIMIS database structure in PostgreSQL: tables, views, user-defined types.
Migrate Stored Procedures and Functions to PostgreSQL. Analyse and propose optimisation during the migration of Stored Procedures. This can also include the replacement of stored procedures by application-level code.
Migrate in-line SQL scripts in all openIMIS related components: Web Application (legacy and modular), REST API, Web Services, Windows Services. Optional: construct SQL scripts using framework's ORM (Entity Framework or Django ORM) to become DBMS independent.
Develop a tool for the transfer of data from the MSSQL database to the PostgreSQL database.
Start the migration of SP from the database level to Python code in the modular backend using Django ORM (DBMS independent).