Share all details related to your problem, including any error messages you may have received.
I am trying to migrate the Sailpoint IdentityIQ DB Schema and stored data to postgres. Is there any guidance or best practice document provided to migrate the data from Oracle to Postgres? Trying to use AWS Cloud services like DMS to enable the replication however those services running into limitations due to large table names then supported table name length.
Did you ever get any feedback on this anywhere else? I am looking to do a migration from Oracle to SQL, and wanted to know if there were any gotchas to keep an eye out for.
I would also be interested if anyone discovered anything here.
We attempted to migrate from mySQL to postgres as part of an 8.3 ->8.4 upgrade but kept running into schema validation issues after loading 8.3 data into the 8.4 schema via pgloader. It looks like postgres upgrade scripts arent provided which is unfortunate.
Hi @rajan_jethva,
Have you got any feedback or any database performance improvements in moving to Postgres sql ? Would be great to hear on the same.
We are also understanding the benefit of moving to AWS aurora. Evaluating what challenges we face in this migration.
It might not be quite what you all are looking for but My company has actually been in the process of migrating from an Oracle DB to an Aurora MySql DB but we are also upgrading our IdentityIQ version from a really old version to at least 8.2. We stood up a vanilla IIQ 8.2 version with the new DB and re-created all of our custom code. Then we created some data migration tasks to re-create the old version identities into our new system and aggregation tasks to pull in and create the application links.
This might mostly be because we are moving from a very old version to a newer IdentityIQ version but it has worked well so far for us.