Well - there are always ways - Oracle -> Db2 -> Postgresql or similar crazy ways. Not that I would recommend it - but I have done a couple of migrations from e.g. Db2 AIX to Db2 linux x86 which is also not supported. This is in general not that big a problem - but what you want to do is of course limit the data as much as possible reducing the time/effort to do the migration.
So - unless really needed - use DBPurge to reduce the amount of data - then check the table sizes - I believe there some of the audit and reconciliation tables that are not pruned - but they can be taken care of in the extract (or pruned manually).
But - in general - export/import -> migrate should be the process - you should build a repeatable process/workflow to handle this so that you can run it multiple times - but I assume already have that planned 😀
------------------------------
Franz Wolfhagen
WW IAM Solution Architect - Certified Consulting IT Specialist
IBM Expert Labs
------------------------------
Original Message:
Sent: Fri April 10, 2026 02:45 AM
From: Viktor Homolya
Subject: Oracle to PostgreSQL migration for IVIGv11
Thanks Franz. I did create a Case meanwhile and have response this is not supported - my understanding is that there is no tool provided for this by IBM. My customer has some experience migrating Oracle to PostgreSQL, I will discuss details with them soon to understand what is doable and what is not.
------------------------------
Viktor Homolya
------------------------------
Original Message:
Sent: Fri April 10, 2026 01:27 AM
From: Franz Wolfhagen
Subject: Oracle to PostgreSQL migration for IVIGv11
There is no automated path. What is needed is an export from the current database and then an import.
I have not hard of anybody trying this yet from Oracle to Postgresql so my advice would be to raise a case.
------------------------------
Franz Wolfhagen
WW IAM Solution Architect - Certified Consulting IT Specialist
IBM Expert Labs