Database migration

Owned by Xavier Gillmann (Unlicensed)

Last updated: Dec 21, 2022 by Marco Kalin

1 min read

The aim of this phase is to switch the data base engine to the target (Postgres) one, without any structure transformation (but create indexes,...).

This phase is NOT iterative/incremental: all tables (modules) are migrated in once.

The target technology stack is based on a ORM (django) and won't make use of any database server-specific (MSSQL nor Postgres) features:

no Stored Procedure
no specific (Transact-SQL) functions

As a consequence, the migration to Postgres server should be limited to a re-location of the tables (and index re-creation,...)

Did you encounter a problem or do you have a suggestion?

Please contact our Service Desk

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. https://creativecommons.org/licenses/by-sa/4.0/