Versions Compared

Old Version 5

changes.mady.by.user Michel Borer

Saved on

compared with

New Version Current

changes.mady.by.user Uwe Wahser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Content

Table of Contents
excludeContent

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 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)
alltrue