Migrating Databases

The Migrate Database wizard is a java-based tool that enables you to migrate data between relational database management systems (RDBMS). For example, you can use the Migrate Database wizard to migrate data from a 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.

Related Topics