Forum Stats

  • 3,826,885 Users
  • 2,260,721 Discussions
  • 7,897,114 Comments

Discussions

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

user10553209
user10553209 Member Posts: 2 Blue Ribbon

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

Answers

  • User_83QR5
    User_83QR5 Member Posts: 1 Red Ribbon

    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
    user10553209 Member Posts: 2 Blue Ribbon

    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