Content
Table of Contents | ||
---|---|---|
|
Objective
Explore the migration of openIMIS database from Microsoft SQL Server to PostgreSQL
...
PostgreSQL versions 11.5 and newer should be considered instead of version 10 that was chosen. Considering You are already requiring 64-bit installations for openIMIS, losing support for 32-bit systems is no downside. Additionally, only versions 11.5 and newer support stored procedures. In older versions these SPs are stored as functions instead.
Some of the columns commented out columns are still required by some functions or procedures, most notably the startcyle1 - startcycle4 columns in the tblProduct table. Thankfully, most of them are correctly defined so that no additional work (beyond uncommenting the lines) is needed. The migration tool also had no issue filling the tables with data, suggesting that the columns are properly defined.
Child Pages
Child pages (Children Display) | ||
---|---|---|
|