Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 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