The Migrate Database wizard is a java-based tool that enables you to migrate data between different Relational Database Management Systems (RDMBS). For example, you can use the Migrate Database wizard to migrate data from an database hosted on Microsoft SQL Server to a database hosted on Oracle Database.
Note: Migration to and from Oracle Autonomous Databases is not yet supported.
Use the Migrate Database wizard to:
- Import data into a newly created database.
- Repair a damaged database to correct database object issues (such as constraints or views).
Do not use the Migrate Database wizard to:
- Convert the database type from EPPM to PPM or from PPM to EPPM (schema migration).
- Upgrade from one database version to another.
- Import data into an existing database.
- Correct data-specific issues.
- Correct schema-related issues. It is not ideal for large databases (more than 10 GB) due to the performance of the wizard. For larger databases, try first to manually resolve schema-related issues.
Before running the Migrate Database wizard, you must first run a schema validation on the database. See Running a Schema Validation on the Database for details.