Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 400 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
How to Migrate PeopleSoft 9.2 DB2 DB v11.1 to PeopleSoft 9.2 Oracle 19c?

user10553209
Member Posts: 2 Blue Ribbon
in Workshops
I know following Tools can be used
- PeopleSoft Datamover Tool if the DB size is < 200 GB
- 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
-
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?
-
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