Schedule - PGConf.EU 2019

Migration to PostgreSQL

Date: 2019-10-15
Time: 09:00–12:30
Room: Monti
Level: Intermediate

Imagine you are requested to migrate a legacy database to PostgreSQL. Just after the excitement generated by this announcement, you'll have to organize your work in order to both not miss a single point and your target to be reached.

Then you'll start the technical work:

• Which questions would you ask whom?
  • Business context, workload
  • Dev: applications, stored procedures and functions
  • Ops: probes, system operations, lifecycle
• How to organize your work?
  • Deadline
  • Primary study (data model, data, functional elements)
  • Details
  • Constraints
• Which tool would you use to migrate?
  • Tools to migrate from Oracle
  • Tools to migrate from MySQL
  • Tools to migrate from SQLServer
• Most common migration scenarios

In this training, you'll learn how to build your own migration workflow and get several tips with various well-known tools including ora2pg, ora_migrator, pg_chameleon, pgloader, foreign data wrapper…

Prerequisites:

• For this training, trainees must have VirtualBox (at least 5.1) already installed and able to run virtual machines. VM images will be provided on a USB key.
• Trainees should have an intermediate knowledge of PostgreSQL and of the source database (Oracle, MySQL, SQLServer).

Slides

The following slides have been made available for this session:

• migrate-to-pg_pgconfeu2019.pdf

Speaker