How to Migrate PeopleSoft 9.2 DB2 DB v11.1 to PeopleSoft 9.2 Oracle 19c?

user10553209

I know following Tools can be used

1. PeopleSoft Datamover Tool if the DB size is < 200 GB
2. DB2 or Oracle using SQL-Developer Tool

Is there any drawback in using the above Tools for the DB version listed. Please let me know.

Thanks,

Ravishankeran.R

User_83QR5

HI Team,

I am also looking for DB2 to Oracle migration but DB size is 2.5 TB , Can you please share tool we can use?

user10553209

Hi,

You can use SQL Developer Tool available in Oracle to migrate DB2 Meta Data along with Data based on the data volume. To move actual Data you might need to split the large volume tables into different set of migration and smaller tables into different set. So, that you can run parallel the data migration from DB2 to Oracle.

Thanks

Ravishankeran.R