Ewen Gallet

DB Migration

Oracle database migration to Postgres.

Reworking SQL series, replacing technologies and update softwares.

Tasks:

• Data transfer and code adaptation
• Choose of technological change, in particular for projects in DELPHI (new ADO)
• Corrections of requests for existing projects as well as VIEWs in the DB
• Creation of a software automating the changes from Oracle and adapt them into Postgres
• Transfer of data from Oracle to Postgres via CSV files, and conversion of the type of columns in Oracle tables to the corresponding type in Postgres

Technologies:

Oracle, Postgres, SQL, ODBC